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 |
|
addytude
Starting Member
12 Posts |
 Posted - 2004-11-10 : 07:58:00
|
| I have situation where i have to every month bring in new data from Text files which are Vertical tab separated in columns and carriage return for every row. The are many such files which are entered into many tables For this i will have to manually do the DTS every month. can we automate the DTS, so that every time i just have to do minimum effort and all the DTS run for the respective files? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-11-10 : 13:36:33
|
| Seehttp://www.nigelrivett.net/ImportTextFiles.htmlDoesn't use dts but will import all files that arrive in a directory.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Automating DTS ??