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!

DTS Package

Hi,

I create DTS Package, when I do the Transform Data Task Properties, the Table/View (Source Tab), and Table Name (Destination Tab), how can I see the whole table name? Especially, Table Name in Destination Tab, it show [database name].[dbo].[table name], I only see the 1st char of the table name in the dropdown list. Could you please let me know how can I resize the dropdownlist in order to see the table name?

Thanks.If you select that column on destination tab, using key board left arrow key you can move to the end of the value.