SQL Server to Snowflake

[JSlatorMHC]

Hi All,

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.

I have attached a copy of the job and the error. Any ideas how i can fix this?

Thanks

[Anonymous · Accepted solution]

Hi

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.

Regards

Shong