December 15, 2008 at 12:57 pm
I have a csv file with two rows. The contents in the file look like this:
7282 1Z9132330343268916,
7283 1Z9132330342623908,1Z9132330344644098,
The first column contains a four digit order number. The second column contains one or more tracking numbers for the order number.
When I've tried different ways to create a flat file connection manager for this. If I don't have a Text Qualifier, set the Header row delimiter as {cr}-{lf}, and the Row delimiter as LF, the data in the preview looks like this:
column 0 column1 column2
7282 "1Z9132330343268916 "
7283 "1Z9132330342623908 1Z9132330344644098,"
If I set up the CM with a " Text Qualifier and leave everything else as is, the data looks like this:
column 0 column 1 column 2
7282 "1Z9132330343268916, 7283 1Z9132330342623908 1Z9132330344644098,
I have a split function that can handle the data as it appears in the CSV file, but I can't seem to get the data set up correctly in the connection manager in order to import the data. The data needs to come into sql server, and should go into the table like this:
OrderNumber TrackingNumber
7282 1Z9132330343268916
7283 1Z9132330342623908
7283 1Z9132330344644098
What can I do to make the data in this CSV file conform?
Thank you for your help!
cdun2
December 15, 2008 at 1:17 pm
Have you tried setting up as a 1 column import? You would then split the data from there.
December 15, 2008 at 1:37 pm
As in using a Derived Column transform to remove the quotation marks and parse the data?
December 15, 2008 at 1:40 pm
I have a csv file with two rows. The contents in the file look like this:
7282 1Z9132330343268916,
7283 1Z9132330342623908,1Z9132330344644098,
What quotes? Your sample above doesn't have any.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply