https://community.qlik.com/t5/Talend-Studio/SQL-Server-to-Snowflake/m-p/2313244#M84118 <P>Hi All,</P><P></P><P></P><P>I am creating some jobs to take data from an application with a SQL Server database and send it straight into snowflake. The job runs fine on some of the tasks but it looks like when it hits a row where there is a ( in the data it fails (the column is set to string in the schema). I cant escape these out as they are application fields. </P><P></P><P></P><P>I have attached a copy of the job and the error. Any ideas how i can fix this?</P><P></P><P></P><P>Thanks</P><P></P><P></P> Fri, 15 Nov 2024 22:43:58 GMT JSlatorMHC 2024-11-15T22:43:58Z https://community.qlik.com/t5/Talend-Studio/SQL-Server-to-Snowflake/m-p/2313244#M84118 <P>Hi All,</P><P></P><P></P><P>I am creating some jobs to take data from an application with a SQL Server database and send it straight into snowflake. The job runs fine on some of the tasks but it looks like when it hits a row where there is a ( in the data it fails (the column is set to string in the schema). I cant escape these out as they are application fields. </P><P></P><P></P><P>I have attached a copy of the job and the error. Any ideas how i can fix this?</P><P></P><P></P><P>Thanks</P><P></P><P></P> Fri, 15 Nov 2024 22:43:58 GMT https://community.qlik.com/t5/Talend-Studio/SQL-Server-to-Snowflake/m-p/2313244#M84118 JSlatorMHC 2024-11-15T22:43:58Z https://community.qlik.com/t5/Talend-Studio/SQL-Server-to-Snowflake/m-p/2313245#M84119 <P>Hi</P><P>For testing, print the value to the console or file, and check which data value contains the special char "(", and check the DB type of this field in DB.</P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Mon, 18 Jul 2022 03:29:29 GMT https://community.qlik.com/t5/Talend-Studio/SQL-Server-to-Snowflake/m-p/2313245#M84119 Anonymous 2022-07-18T03:29:29Z