CODEWITHSUNDEEP
sql-serversql-server-2005ssis
goofyui
goofyui

Reputation: 3492

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 every column header or field value !!

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

Upvotes: 1

Views: 13538

Answers (3)

Paul Perigny
Paul Perigny

Reputation: 973

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

Upvotes: 4

JeffO
JeffO

Reputation: 8053

Enter " double quotes as the Text Qualifier.

Upvotes: 1

Sankar Reddy
Sankar Reddy

Reputation: 1499

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

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

Upvotes: 3

Related Questions