SSIS Package: Truncation may occur due to inserting data from data flow column

Scenario - During SSIS development work I found a warning message over a data flow task.

(Find the below screen shot for your reference)






Root cause  - This warning message appears over the SSIS data flow task when the datatype length of the source column is more than the datatype length of the destination column.

Resolution - In order to remove this warning message from SSIS solution, make sure datatype length of the source column should be equal to the datatype length of the destination column

There can be two possible approaches to resolve this warning message -

1. Using Advance editor 

Step 1 - Right click to the data source(Oledb Source) and select "Show Advanced Editor", then go to Input and Output Properties tab.

Step 2 - Select Oledb Source Output then expand output columns.

Step 3 - Choose appropriate column and you can change the column data type as well as length of it.
(Find the below screen shot for your reference)




























2. Using Data Conversion 
Take a data conversion task to manipulate the data type length of that particular column.

As soon as source and destination data type length will be equal, warning message will be disappeared

I hope this article will help to prepare a clean SSIS solution without any warning message.

Post a Comment

12 Comments