asked
SSIS Execute Package Task
Hi Forum, * 20 child packages are executed by a master SSIS package. All child packages run in parallel within the master package. * Each package has several variables. They are all identical across packages. * I cannot create SSIS package configurations because I cannot modify the 20 child pacakges. * I need to set all 20 package variables at the same time (they run in parallel). I'd like to do this with a script within the master pacakge. How can I do this?
This is how I've understood variable passing between packages: If you cannot create configurations in the child packages, I'd say you're out of luck. The variables in the child packages are scoped inside the package, and can therefore not be accessed from outside. I child package can read its parent packages in a script task, but not the other way around.
