is there a way within dts to run a select query and output the result set
into a text file???

tia

jt

Just click on File | Save As in the results window to save to a text file.
If you want a particular format, go to Tools | Options | Results -- you can
set it comma separated (CSV) or tab delimited.

CSV is a good format for importing into Excel.

--
************************************************** *****************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1 (AT) NOMORESPAM (DOT) yahoo.com

Please remove NOMORESPAM before replying.

Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.

This posting is provided "as is" with no warranties
and confers no rights.

************************************************** *****************
"JT" <jt (AT) nospam (DOT) com> wrote