Share via

SSIS: Passing variable values from a parent package to child package

  • Article

Recently had to write a complex package where we set the value of a variable in a package and wanted the same value to be sent to the child package to keep the package running smoothly and efficiently. So here's what we did:

Example: Variable name: Brand

1- Dynamically set the value of the variable Brand in the parent package.

2- Declare a variable with the same name Brand in the child package

3- Go to Package Configurations Organizer

4- Create a configuration using the "parent package configuration" type

5- Set up this configuration using the following steps:

Voila! You're done! Hope this helped :)