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