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 |
|
patla4u
Starting Member
10 Posts |
 Posted - 2011-06-28 : 19:58:52
|
| Hello,I have 10 different Packages and they are loading data from text file to staging database. I have 1 master package that loads the data from staging to production database.How can I schedule a package ....like master package knows that all 10 packages executed sucessfully in staging ,,,,and then execute master package.Means I want to execute master package automatically if all 10 different packages loads successfully....If one package fails then master package knows that 1 package is failed and do not execute....Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-28 : 22:18:03
|
| You can use SSIS Execute Package TaskBut I'd make 'em all steps in a SQL Agent job instead. |
 |
|
|
|
|
|
calling another packages