Import .csv file through SSIS Package without double Quotes

SQL 2005

I am importing .csv file to SQL Table through SSIS Package !! On doing so, I am getting double quotes on ev开发者_开发知识库ery column header or field value !!

How to remove double quotes, while importing .csv file ???

The csv file is using the " as a text qualifier.

When importing you must specify inform SSIS of this.

See How to strip out double quotes from an import file in SQL Server Integration Services SSIS

Add " as the Text Qualifier when choosing the source (csv file)

http://twitpic.com/4k3ok8/full

Enter " double quotes as the Text Qualifier.