October 28, 2010 at 2:15 am
Hi,
I m getting CSV file from my Client on a daily basis.
I m trying to load the data using SSIS package, But for few fields the data is concartinating with the two or more column data.
For Example
They are four fields in the CSV file Summary, Company, Number, Location ,Date
For few fields Company row is getting updated with Summary field data.
Number field is getting updated with Company data.
Date field is getting updated with Company data.
How to set the data properly to the concerned fields. I have tried changing the options in Flat File connection manager but no success.
Please help.
October 28, 2010 at 9:07 am
Is it possible that the .csv file your importing isn't formatted correctly?
It looks like the problem tends to start with the Company field, and a lot of companies have commas in their name. (i.e. ABC Co., Inc.) which would be interpreted as Company = ABC Co. Number = Inc. unless the Company field uses a text qualifier such as double quotes.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply