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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-14 : 09:14:48
|
| Phil writes "Hi,I would like to use DTS export to export data from one table on one server to another table on a different server (between SQL 2000 servers). If this job succeeds I want to delete the data on the table that was doing the exporting. How can I create a DTS package that will execute some SQL delete statement if and only if a DTS export wizard job was successful beforehand?Thanks,Phil" |
|
|
tacket
Starting Member
47 Posts |
Posted - 2002-10-14 : 11:15:20
|
| I answered my own question on this one. That DTS package interface is intimadating at first, but once I got into it, it was pretty powerful and user friendly. You can move around tasks, make tasks only execute if others succeed and so on. I guess this was a RTFM question :)Phil |
 |
|
|
|
|
|
DTS package