You can create files in DTS with ActiveX script
Look up  CreateObject("Scripting.FileSystemObject")

Here is a link
http://msdn.microsoft.com/library/default.asp?url=3D/library/en-us/script
5
6/html/sgfsosample.asp

First step create the file use a file name with the minutes and seconds,
in case if you execute this package more than once a minute

Step 2 populate the file with transform datatask

Step 3  archive the file


-----Original Message-----
From: henry [mailto:henryh@p...]
Sent: Wednesday, July 03, 2002 11:15 AM
To: sql language
Subject: [sql_language] RE: Copy to a CSV


Again I need it to copy many different files 1 after another with no one
near the computer to run the next file. In query analyzer you can run a
script to run 1 after another i need to know a way to "SELECT * INTO a
csv file" if that is even possible!

-----Original Message-----
From: Denis Gobo [mailto:dgobo@w...]
Sent: Wednesday, July 03, 2002 11:06 AM
To: sql language
Subject: [sql_language] RE: Copy to a CSV


Use dts and export to Excel

-----Original Message-----
From: henry [mailto:henryh@p...]
Sent: Wednesday, July 03, 2002 11:04 AM
To: sql language
Subject: [sql_language] RE: Copy to a CSV


I need it to run a bunch of different files 1 after another without
someone being here and hitting save every time.

-----Original Message-----
From: Nick McNair [mailto:Nick.McNair@A...]
Sent: Wednesday, July 03, 2002 11:01 AM
To: sql language
Subject: [sql_language] RE: Copy to a CSV


Henry,

From query analyser:

	Query
		Current connection options
			advanced tab
				pick 'comma separated (CSV)' from Result
output window

Nick

-----Original Message-----
From: henryh@p... [mailto:henryh@p...]
Sent: 03 July 2002 17:03
To: sql language
Subject: [sql_language] Copy to a CSV


I was wondering how to copy to a CSV from query analyzer. I do not want
to use BCP

Thanks


*********************************************************************
This message and any attachments are confidential and should only be
read by those to whom they are addressed. If you are not the intended
recipient, please contact us, delete the message from your computer
and destroy any copies. Any distribution or copying without our prior
permission is prohibited.

The Achilles Group does not accept legal responsibility for the
contents of this message. The recipient is responsible for verifying
its authenticity before acting on the contents. Any views or opinions
presented are solely those of the author and do not necessarily
represent those of the Achilles Group.

This email has been scanned by MAILsweeper and Sophos Anti-Virus
products. However, The Achilles Group will have no liability for any
viruses contained in this email or any attachment with this email.
*********************************************************************




**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error please notify the
system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************





**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error please notify the
system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************