I have a flat file that uses | to separate the fields and does not use a text indicator. (I have no control over the formatting of the flat file.)
The file contains a string field, and the data contained in it some times contains text that includes a carriage return.
When SSIS attempts to import the file, it sees the carriage return in the text field and misinterprets it to mean that the line of data is at its end and it starts a new record.
This then throws the rest of the import off and stops the process.
Note that I can't use a Derived Column Transformation function within SSIS because the data doesn't get past the Flat File Import function.
I'd appreciate any suggestions as to how to handle this issue.