Hello,
I'm running into an issue on importing datas from a .csv file to sql 2005 database.
All my datas has been imported successfully but the datas with doublequotes(") are imported along with additional double quotes.
For example, a cell has the data, iron rod - 34" and this has been imported as "iron rod - 34"""
Can anyone please help me to come out of this issue.
Thanks.
Raviraj Danasekaran
If you are using integration services wizard then set the text qualifier to " in the flat file source connection settings