Truncation Error in SSIS Package.. Need help

11y966

I always gets truncation error in destination in my package. Sometimes data types do not match and sometimes size of data.
To fix it, I use the advanced editor and in the tab "Input and output properties",
I change the data type or size in external columns to match them with input columns accordingly.
But I doubt if it is the right way to handle such error. Or data convertion tools is the best way to handle such errors.
Right now i have such errors in all over my package. Please advice me..

3 Replies

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

Priyaranjan K S11y ago
Accepted answer
Gaurav ,

Usually Truncation errors happen in SSIS when we try to fit in column of a particular data type into another or when we try to assign a column of same data type but different lengths into each other . The only reliable solution that helps to work around this situation is to add an extra step between the source and destination - "Add Data Conversion " . We normally use this as the intermediate step to ensure the correct data conversion and trap the errors .

This is a good article for better reference :
https://www.mssqltips.com/sqlservertip/3046/sql-server-integration-services-data-type-conversion-testing/

Thanks,
Priyan

If you found this useful Please mark this as Answer
11y ago
SQLServer,
Input column - data type : DT_WSTR, Length : 50
External Column - data type : four-byte signed integer [DT_I4] Length: 0
Priyaranjan K S11y ago
Hi Gaurav ,

What is your source and destination . Also mention the source and destination data types.

Thanks,
Priyan