Forum Discussion

mohit's avatar
mohit
New Contributor
6 years ago

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

2 Replies

  • thilkip's avatar
    thilkip
    New Contributor
    5 years ago

    Thank you for your time and help. We did validate the script in ultra task and saw the same behavior like earlier.

    We will test the other approach using Formatter snap and let you know.

    Thank you again

    • vamsi's avatar
      vamsi
      New Contributor II
      4 years ago

      @thilkip Have you been able to achieve this scenario using the Script in the Ultra sscenario. We ran in to the same problem