ssis
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
You've come across a fairly well-known problem. When SSIS is trying to import the data, it provides locale-aware conversions and the format YYYYMMDD doesn't convert nicely. You can use the "import as string and convert to actual datetime" approach you've outlined in your solution but that's slower and consumes more resources than using the native approach of telling SSIS to quit being so damn smart.
Right click on your flat file source and select the Show Advanced Editor. In the Input and Output Properties, expand Output Columns, find your column (BirthDate) and change the FastParse property from False to True.
With only that change, the package will execute successfully
Also, an excellent answer from SO on the same issue
That's either a problem with MySql or with the driver you're using. All SSIS knows is that the driver says 'I can't do that'.
The place to start is by manually inserting as record of that kind into the destination db and looking for a more meaningful error.
Best Answer
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 -