patternMinor
SSIS Package Truncation may occur due to inserting data from data flow column
Viewed 0 times
dueflowmaypackagecolumnssistruncationdatainsertingfrom
Problem
I've a dataflow in SSIS 2008. It reads the data from flat file and inserts in to database.
The flat file is CSV. For some reason, all the fields in flat file connection manager seems to have 50 OutPutColumnWidth.
Could someone please suggest how to fix it. I'm getting error below:
Truncation may occur due to inserting data from data flow column
The flat file is CSV. For some reason, all the fields in flat file connection manager seems to have 50 OutPutColumnWidth.
Could someone please suggest how to fix it. I'm getting error below:
Truncation may occur due to inserting data from data flow column
Solution
This warning message displays when any time source column data type length will be more than then length of destination datatype. To resolve the warning message check here -
Context
StackExchange Database Administrators Q#56668, answer score: 2
Revisions (0)
No revisions yet.