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 |
|
bridge
Yak Posting Veteran
93 Posts |
 Posted - 2005-09-28 : 03:24:13
|
| If data has to be exported into .txt files from different tables. Say from Users table to Users.txt, GL to GL.txt, Customers to Customers.txt and similary for rest of the tables(30). Then for each export a single DTS package is good to make or individual DTS packages should be made? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-09-28 : 03:40:37
|
| ah i recommend visiting nr's sitehttp://www.mindsdoor.net/#DTSalso check out his bcp routine to automate your task,http://www.mindsdoor.net/SQLTsql/BCPAllTables.htmlsave the table names of the tables you need to dts in another table and use that input for the bcpHTH--------------------keeping it simple... |
 |
|
|
|
|
|
DTS