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 |
|
timsweet
Starting Member
31 Posts |
 Posted - 2005-09-12 : 14:27:24
|
| I have a series of DTS/DDQ that I want to call at one time and have each one run in sequence.Can a package be created that will run these, rather then schedule each one to run separately?Thanks in advance.Tim Sweet |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2005-09-12 : 17:00:10
|
| In a DTS package there's an Execute Package Task you can use to execute a DTS package. You could put a series of those in a package and link them through precedence constraints. Or you could make each package a step in a job and run them that way.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
 |
|
|
timsweet
Starting Member
31 Posts |
Posted - 2005-09-12 : 17:56:01
|
| That's what I did..and it works find...thanks. |
|
|
|
|
|
|
DTS/DDQ