I recently came across a roadblock in an SSIS project — how to pass the variables scoped in one package to a “child” package executed via an “Execute Package Task”. Like most SSIS speedbumps, the solution was easy to implement once I found the answer (at SQLIS.com) — Package Configurations.
On the menu bar: SSIS >> Package Configuration ….
From the Configuration Type dialog, select “Parent package variable” and go through the wizard to map the Parent package variable to the variable in this Child package
