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
 Import/Export (DTS) and Replication (2000)
 How to Send SP Results to CSV File in DTS?

Author  Topic 

DBADave
Constraint Violating Yak Guru

366 Posts

Posted - 2004-01-09 : 11:25:55
How do I setup DTS to invoke a stored procedure and have the results written to a CSV file?

Thanks, Dave

scottpt
Posting Yak Master

186 Posts

Posted - 2004-01-09 : 11:31:26
Have the stored proc load a temp table then do a select from the temp table.
Go to Top of Page

DBADave
Constraint Violating Yak Guru

366 Posts

Posted - 2004-01-09 : 11:51:24
Not sure I follow you. How does that get the results stored in a CSV file?

Dave
Go to Top of Page
   

- Advertisement -