Showing posts with label quotes. Show all posts
Showing posts with label quotes. Show all posts

Tuesday, March 27, 2012

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?

ThanksThank you, Ray. That did it!
"Ray Higdon" <rayhigdon@.higdonconsulting.com> wrote in message
news:3f280abb$0$197$75868355@.news.frii.net...
> 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!

Tuesday, February 14, 2012

DTS Import "" Delimiter Bug

I have a pipe delimited file that has text fields that are quantified with double quotes "" and after the 15th column, DTS seems to not know how to deal with the quotes and appears to be buggy. It will import a column and keep the quotes on or import it and the left quote will stay on and not the right. I had another fellow programmer look at it and he could not figure it out. Any ideas? is this a bug?It sounds like you have your text qualifier set. Change it to none.