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 |
|
jrockfl
Posting Yak Master
223 Posts |
 Posted - 2004-08-03 : 10:55:05
|
| I have have 3 different DTS packages that I created with the wizard that I would like to combine into 1. Currently DTS1 executes at 8:00AM DTS2 at 8:30AM and DTS3 at 9:00amIs it possible to combine these so that when DTS1 completes DTS2 executes and so forth? |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-08-03 : 11:05:14
|
| You can do this by running them in a SQL server agent Job.In each step In the command syntax you can put:DtsRun /S(Local) /E /N"DTS1"But you should read up about it in Books on lineDuane. |
 |
|
|
Hyukevain
Yak Posting Veteran
66 Posts |
Posted - 2004-08-04 : 03:48:53
|
| Create a new dts package, insert all 3 DTS you want to run into the new package using "execute package task", set the workflow step and schedule the new package at 8:00 AM. |
|
|
|
|
|
|
Combine Multiple DTS Packages