July 8, 2008 at 6:34 am
Hi all, probably straight forward stuff but I've got a problem loading a .csv file that now has its field values wrapped in double quotes. I'm using a DTS package for this and the problem is that even though I've set the row & field delimitters and set the text qulaifier, the data is being loaded with the double quotes. Eg. if I load the data and then select say...the forename field instead of getting the actual value - Keith I'm getting - "Keith".
Cheers for any help,
WILL
July 8, 2008 at 8:30 am
Well, if anyone else gets this problem you need to set the text qualifier not only in the pump task but also in the source file object too. The issue for me was also clouded by the source file containg two sets of text qualifiers within the same field.
e.g. "xx","was it "working" before","yyy","zz"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply