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 demonstrates the logic inherent to an Extract, Transform, and Load (ETL) project. ETL is a project that, by nature, is divided into three stages: the first stage is responsible for extracting data from sources, the second stage is responsible for the...