Hi,

i have a flat file (comma-delimited) that can carry records with as few as
10 columns (first record) and as many as 18. When the Flat File connection
manager attempts to "understand" the file, it forces all records into the 10
column format, lumping values from columns 11+ into the 10th column for
records with more than 10 columns.

Adding more columns manually does not help, as SSIS stops recognizing CR/LF
as the record delimiter, and begins placing columns from 2nd record into
columns 11-18 of the first record.

Any ideas on how this can be addressed gracefully w/ SSIS?

thanks!