String data, right truncation Error while loading data from Snowflake to SQLserver

Hi guys,

I am trying to load the data from Snowflake to SQL server with the use of SQL Server Bulk load snap and I am using BCP too in that snap. But I am facing the ‘String data, right truncation’ Error.The Max length of the source column is varchar(1000). I changed the Length of column on destination to ‘TEXT’ which is maximum. But still I am facing the issue.

Can Anyone help.

Thanks