I'm trying to import a CSV file in SSIS 2008, but I'm having an issue with the comma as a delimiter. Every cell is enclosed in quotation marks & a comma divides them, however there are also commas within the data. As a result, the output is skewed. The file is written something like this:"Part Number", "Brand","Quantity","Price","Description","Return Policy""Playstation","Sony","2","505.30","This is a game console","yes""Ipod","Apple","2","300.30","This device can play MP3, MP4, and MOV files","yes""Zen","Creative","40","44.48","This is an MP3 player","yes""HDJ-2000","Pioneer","20","150.88","This is a high end headphone","yes"
But the output looks like this because the commas are throwing it off:Part Number Brand Quantity Price Description Return Policy Playstation Sony 2 505.3 This is a game console yes Ipod Apple 2 300.3 This device can play MP3 MP4 and MOV filesZen Creative 40 44.48 This is an MP3 player yes HDJ-2000 Pioneer 20 150.88 This is a high end headphone yes
Is there any way to tell SSIS that only the commas within the quotation marks are delimiters? Microsoft Excel interprets the file correctly without an issue.EDIT: The output is less than clear. In row #2, the "Description" Field has commas within it and that throws off the input of the "Return Policy" field and anything thereafter.
Importing CSV in SSIS 2008
Posted - 2011-10-08 : 01:23:45
