March 19, 2014 at 5:07 am
Hi all,
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.
There are no other row delimiters in the file.
Sample data (from the end of one "row", across the beginning of another):
AFRL|1
Bosch
As you see, although I copied a single line of data from the csv file, when pasted HERE, it appears over TWO lines, so I know there is a carriage return involved.
Now, there's a header in the file as follows...
XXXXX19032014
Without this, the file imports perfectly, but I cannot strip this out as it is required for later validation .
Would be grateful for a workaround,
Jake
March 20, 2014 at 2:26 pm
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 .
I'm assuming you've set up a flat file connection manager. Are you specifying header rows to skip?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply