Hi,
I need to execute 29 ssis packages. So planning to create one master package which will execute all these packages. I don't know how to implement this. Can you please explain in brief. Thanks in Advance !
+1
A:
This article does a pretty good job on giving a high level summary of what a master package does, which is basically a package executing other packages in the control flow: http://dichotic.wordpress.com/2006/10/30/creating-the-master-package/
This article goes over logging, variable scope, transactions, etc. from a fairly high level : http://74.125.95.132/search?q=cache:zMWg5KkFGZcJ:dmachicago.com/WhitePapers/SSIS%2520Master%2520Control%2520Package.doc+ssis+master+package+template&cd=3&hl=en&ct=clnk&gl=us
rfonn
2009-11-16 13:49:04
A:
Alternativly, just use the execute package task. You have to deploy your ssis packages to the server first for this to work.
Mr Shoubs
2010-03-05 10:24:51