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
 SQL Server Development (2000)
 Create file from results of query

Author  Topic 

rbohaty
Yak Posting Veteran

71 Posts

Posted - 2004-07-30 : 15:45:43
How can I create a script that executes a query then saves the results out to a csv file? Should I go with DTS if so are there examples of how to set this up? Can I do this with the script and are there examples for this also?

Thanx

X002548
Not Just a Number

15586 Posts

Posted - 2004-07-30 : 15:49:33
I would create a view and bcp it out....

And I would make it TAB delimited

Or you can use DTS



Brett

8-)
Go to Top of Page
   

- Advertisement -