Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Query Output To A File

Author  Topic 

TonyTheDBA
Posting Yak Master

121 Posts

Posted - 2007-06-26 : 09:59:01
Apart from the osql utility is there anyway to output the results of a query to a file?

I have come up with a way using DTS, but the pain is that I need to change the output filename to reflect the date the job was run. I guess that I can either add a DTS VB Script Job to rename the file produced by the earlier steps in the DTS, or add a CMDExec step in the Job to do the same.



--
Regards
Tony The DBA

pootle_flump

1064 Posts

Posted - 2007-06-26 : 11:11:09
BCP?
Go to Top of Page
   

- Advertisement -