DTS Question

#1

I have a DTS job that exports into a tab-delimited file. The tab delimiting
is working great BUT it also using quotes around the fields as well. (I
assume because they are string vars). Can this quoting "feature" be turned
off?

Thanks

#2

Thank you, Ray. That did it!
"Ray Higdon" <rayhigdon (AT) higdonconsulting (DOT) com> wrote

Quote:

Yes, open the connection to your text file in dts designer and go to
properties, there you will be able to specify if you want double-quotes
as a text qualifier,row-delimiters, column delimiters, etc.

HTH

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

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

DTS Question

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

DTS Question - 07-30-2003 , 10:50 AM

Re: DTS Question - 07-30-2003 , 02:35 PM