Jake Shelton (3/19/2014)

---

<Shortened>

Am importing from a vertical-bar column-delimited CSV file that looks like a heap when open but imports perfectly in DTS.

However I have tried all available Row delimiters including CR, CR+LF, and LF, but the first two return 16,000 columns and 1 row, whereas the LF returns one enormous column.

Now, there's a header in the file as follows...

Without this, the file imports perfectly, but I cannot strip this out as it is required for later validation .