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)
 automate data export

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-06 : 00:12:36
Sonica writes "I would like to export data from one table defined in MS SQL Server 7.0 into a tab-delimited text file. So just dump all the data in all columns in a given table into a text file - Instead of using DTS, I'd like to do it through a batch file or a script that can be run from the command line. Could you include a sample if possible. This is really urgent - thanks a bunch for the help!"
   

- Advertisement -