CRLF not being read

Jan 25, 2011 at 6:42 PM

I have installed the Delimited File Source and created a very simple .txt file with 3 columns ending with a CRLF. The values are comma separated and enclosed in double quotes. I have the "Text qualifier" as ". The "Header row delimiter as {CR}{LF}. I've checked the "Column names in the first data row" and the "Treat empty strings as null" boxes. The "Row delimiter" is {CR}{LF} and the "Column delimiter" is Comma {,} (in the columns dialog box).

This is what my data file looks like:


When I click on columns I see:

mycolumn1  mycolumn2  mycolumn3"c1"  c2  c3"c11" c22 c33

It appears that the CRLF is not being read.

Anyone know what I need to do?