I have a large flat file that I use to recover data. It was exported from the system using double quotes "as qualifier and channel |", and a delimiter. SSIS can be configured to do this without problems, but where I run into problems is with \ escape char.
line causing the problem:
"125004267"|"125000316"|"125000491"|"height"|"5' 11\""|"12037"|"46403"|""|"t"|""|"2012-10-01 22:34:01"|"2012-10-01 22:34:01"|"1900-01-01 00:00:00"
The fourth column in the database should be 5 '11 ".
I get the following error:
Error: 0xC0202055 in data stream 1, source of flat file [2]: column delimiter for column "posting_value" was not found.
How can I tell SSIS to process the \escape character ?
source
share