Loading

Truncation error

11y926

I have a destination table with a column nchar(2).
When i add a column by derived column tool, its data type became DT_WSTR and length 50.
Due to which i am getting truncation error. How do i fix the error without changing destination table.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Priyaranjan K S11y ago
Accepted answer
Gaurav,

Use a Data Conversion Task so that it matches the input of the Destination Table :

Here is a good link :
https://www.mssqltips.com/sqlservertip/3046/sql-server-integration-services-data-type-conversion-testing/
https://ericwisdahl.wordpress.com/2011/06/16/ssis-quick-tip-data-conversion-task-or-cast-in-source/

Thanks,
Priyan

If you found this useful Please Accept this as Answer