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)
 Save query results

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-07-16 : 07:21:18
Rebecca writes "When running a SELECT statement how do I save the query results in a specified file?"

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2003-07-16 : 10:11:02
You can use BCP with the OUT parameter, or you can use the Write File transformation in the Data Pump task of DTS.

Jonathan
{0}
Go to Top of Page
   

- Advertisement -