The row delimiter cannot be the same as the column delimiter

Question

When I try to add a column and set the ColumnDelimiter in the Flat File Connection Manager Editor, I get the error:

The row delimiter cannot be the same as the column delimiter.

How can I specify the delimiter?

Answer 1

Yes this error is obvious , please select from flat file connection manager row delimiter as {CR}{LF} and any of the highlighter for column delimiter , you will not get the error.

Generally we use {CR}{LF} as to read the end of line, please check the definition below for {CR}{LF}.

End of Line characters include CR or LF. Windows uses both {CR}{LF} at the end of a line, whereas Unix uses only a LF.

• CR = Carriage Return
• LF = Line Feed

please follow the snapshot and choose the highlighted delimiter as column delimiter to avoid the error in your package.