Symptoms
In Microsoft SQL Server 2008, when you use the Flat File source to enable a package to read data from a text file, or you use the Flat File connection manager to enable a package to extract and load data from a flat file, some rows are parsed incorrectly. Additionally, data may beattributed to the wrong columns in some rows.
This problem occurs for one of the following reasons:The flat file contains comma-separated values (CSV).The flat file contains a different delimiterthat contains a variable number of columns.
Resolution
This problem occurs because the Flat File source and the Flat File connection manager in SQL Server 2008 Integrated Services (SSIS) do not support “Ragged right format” reading of delimited flat files if the files contain a different number of delimiters in the rows.
Note This problem may cause the parser to read ahead and fill the rest of the row with values from the next row.