Thursday, September 12, 2013

Fix: SSIS Warning of Truncation From Database to Data Flow Column

The error appears as follows, even after verifying matching source --> destination length.

Validation warning. [PackageName] {GUID}: Truncation may occur due to retrieving data from database column "[SourceColumnName]" with a length of (x) to data flow column "DataFlowColumnName]" with a length of (y).

To fix, open the data flow task. Select columns, then deselect the columns, and re-select all needed columns.

This was seen with SSIS 2012.

No comments:

Post a Comment