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.