DTS Question

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • gremlin

    DTS Question

    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


  • gremlin

    #2
    Re: DTS Question

    Thank you, Ray. That did it!
    "Ray Higdon" <rayhigdon@higd onconsulting.co m> wrote in message
    news:3f280abb$0 $197$75868355@n ews.frii.net...[color=blue]
    > 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![/color]


    Comment

    Working...