Mark Forums Read

Strip double quotes via SSIS

Go Back

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Reply

#1

Old

jmelkerson

Posts: n/a

Strip double quotes via SSIS - 03-26-2008 , 07:25 AM

I am using SSIS to import a CSV file into a SQL table. How do I strip the
double quote marks surrounding the strings in the CSV file? This seems like
a super-simple transformation but I can't figure it out.

Reply With Quote

#2

Old

jhofmeyr@googlemail.com

Posts: n/a

Re: Strip double quotes via SSIS - 03-26-2008 , 09:34 AM

Hi jmelkerson,

Assuming the double quotes are being used to denote text fields, you
can simply configure your flat file connection manager with double
quote as the text delimiter. This should automatically remove them
when reading the data.

Good luck!
J

Reply With Quote

#3

Old

jhofmeyr@googlemail.com

Posts: n/a

Re: Strip double quotes via SSIS - 03-26-2008 , 09:34 AM

Hi jmelkerson,

Assuming the double quotes are being used to denote text fields, you
can simply configure your flat file connection manager with double
quote as the text delimiter. This should automatically remove them
when reading the data.

Good luck!
J

Reply With Quote

#4

Old

jhofmeyr@googlemail.com

Posts: n/a

Re: Strip double quotes via SSIS - 03-26-2008 , 09:34 AM

Hi jmelkerson,

Assuming the double quotes are being used to denote text fields, you
can simply configure your flat file connection manager with double
quote as the text delimiter. This should automatically remove them
when reading the data.

Good luck!
J

Reply With Quote

#5

Old

jhofmeyr@googlemail.com

Posts: n/a

Re: Strip double quotes via SSIS - 03-26-2008 , 09:34 AM

Hi jmelkerson,

Assuming the double quotes are being used to denote text fields, you
can simply configure your flat file connection manager with double
quote as the text delimiter. This should automatically remove them
when reading the data.

Good luck!
J

Reply With Quote

#6

Old

jhofmeyr@googlemail.com

Posts: n/a

Re: Strip double quotes via SSIS - 03-26-2008 , 09:34 AM

Hi jmelkerson,

Assuming the double quotes are being used to denote text fields, you
can simply configure your flat file connection manager with double
quote as the text delimiter. This should automatically remove them
when reading the data.

Good luck!
J

Reply With Quote

#7

Old

jhofmeyr@googlemail.com

Posts: n/a

Re: Strip double quotes via SSIS - 03-26-2008 , 09:34 AM

Hi jmelkerson,

Assuming the double quotes are being used to denote text fields, you
can simply configure your flat file connection manager with double
quote as the text delimiter. This should automatically remove them
when reading the data.

Good luck!
J

Reply With Quote

#8

Old

jhofmeyr@googlemail.com

Posts: n/a

Re: Strip double quotes via SSIS - 03-26-2008 , 09:34 AM

Hi jmelkerson,

Assuming the double quotes are being used to denote text fields, you
can simply configure your flat file connection manager with double
quote as the text delimiter. This should automatically remove them
when reading the data.

Good luck!
J

Reply With Quote

#9

Old

jhofmeyr@googlemail.com

Posts: n/a

Re: Strip double quotes via SSIS - 03-26-2008 , 09:34 AM

Hi jmelkerson,

Assuming the double quotes are being used to denote text fields, you
can simply configure your flat file connection manager with double
quote as the text delimiter. This should automatically remove them
when reading the data.

Good luck!
J

Reply With Quote

Reply

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.