Truncation Error in SSIS Package.. Need help

Question

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..

Priyaranjan K S · 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

Gaurav Singh · Answer

SQLServer Input column - data type : DT_WSTR Length : 50 External Column - data type : four-byte signed integer [DT_I4] Length: 0

Priyaranjan K S · Answer

Hi Gaurav  What is your source and destination . Also mention the source and destination data types. Thanks Priyan