O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Executing other packages: Execute Package Task

The Execute Package Task executes another package (known as the child) from the current package (known as the parent). This parent-child approach is fundamental:

  • When the project needs to be developed by more than one person (it's easier when you delegate tasks to each team member).
  • While breaking down complex package workflow (also reusing parts of packages).
  • To have a more organized project, reducing the risk of failures and their impact when a specific or small subset of the project must be updated or refined.

It's not recommended to try to do all your work inside one package; the project should be divided into several components that can work together and be called by a parent package.

This recipe ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required