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