--SQL Server 2000
When i run my DTS package, it exports a table with one
column to a text file, but the data comes out in double
quotes... I don't want it in double quotes. How do i
get around this problem.

thank you

Tim

In message <1161601c3f4ca$80ec5950$a601280a (AT) phx (DOT) gbl>, TIM
<anonymous (AT) discussions (DOT) microsoft.com> writes
Have a closer look at the destination settings (Text File Connection)
and you will see the "Text qualifier" option, change this to <none>.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Darren your message didn't post

Thanks
Tim

In message <10b1d01c3f4da$42c35010$a101280a (AT) phx (DOT) gbl>,
anonymous (AT) discussions (DOT) microsoft.com writes
And again...

Have a closer look at the destination settings (Text File Connection)
and you will see the "Text qualifier" option, change this to <none>.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

IT seems what every i change that to in that field it
still spits out in double quotes... set to none or
single or double reguard less it spits out double...

thanks

Tim