Execute Package Task

The Execute Package Task brings the benefits of modular design to SSIS packages. It allows an SSIS (parent) package to run other (child) packages as part of a workflow. This task can be used to run packages stored either in SQL Server msdb database or on the file system.

While developing a solution for a business problem, you tend to build smaller packages meeting specific needs. This approach is recommended as it helps your solution to be modular, which is easier to debug. This also helps you achieve quick results on some of the specific requirements. Once you have built all the modules of your complete solution, you can use the Execute Package task to fit all the smaller packages together to form an enterprise-wide solution. ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.