Hi,
i have a single csv that contains data with multiple delimiter.
I tried to import it as a flat file into SSIS, but it was unable to split successfully using data flow task
Planning to export it as csv with comma delimiter
Sample data of two record:
"ID-001|""abc""|""s1234""|""ab"|{CR}{LF}"test""|""others"""{CR}{LR},,
"ID-002|""abc""|""s4567""|""ab"|{CR}{LF}"test2""|""others2"""{CR}{LR},,
I tried using the following values:
- text delimiter: ""
- row delimiter: {,}{,}
- column delimiter: {|}
SSIS splits the one record into 2 rows which is not what i wanted.
It keeps separating one record into two records. it split at value "test"
Any help is greatly appreciated


