Hello All

Truncation may occur due to inserting data from data flow column "column_name" with a length of 77 to database column "column_name" with a length of 7."

To resolve this, I had to:

open the Data Flow task

From the source task right click and select

open Advanced Editor.

go to Input and Output Properties tab

expand OLE DB Source Output

Expand External columns and check the specific columns

which give the error and the corresponding length.

This length should ideally be the lenght of the column as designed in your database table.

Now Expand Output Columns

click on corresponding column which gives the error and you vcan notice that the length value won't be the same as that in your external column or your database design .

change Length property of the column to that of the actual table design length and refresh .

I also went to target side:

open Advanced Editor (on OLE DB Destination)

go to Input and Output Properties tab

Click on Refresh button

and also ensure to check the value of the length is reflecting correctly.

The truncation warnings vanished immedaitely 🙂