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.
| Author |
Topic |
|
rhofing
Starting Member
15 Posts |
 Posted - 2001-11-05 : 09:50:21
|
| I would like to ask if anyone knows of an easier way to perform an export task that I have to perform: I need to export a number of tables in a DB to text format. I use DTS for this. The problem is I have to specify the output file name and properties for every table and destination text file.This can be tiring if there are a lot of tables involved. I did write an SQL script that used BCP and xp_cmdshell and a cursor to keep track of the tables name and filenames, etc but this is not the most efficient way. Nor would it be easy for a non-DBA type user to run.I was thinking about writing a VB/SQL-DMO app to do this but I thought I would post here first and ask if anyone knows of a way or tool that already exists.Thanks everyone!Ric |
|
|
|
|
|
Export data to text files