How to pass the parent value of a variable to a child package for a reference type: External Reference

Question

I have a ssis project in which the main package contains many child packages. The entire child package is invoked with the task of executing the package. I need to pass the "start date" value from the wizard to the entire child package. I know that we have a parameter binding option in which we can pass the value of a variable. It works only for reference to the project. But the problem is that all child packages are of reference type as "External link". Therefore, parameter binding is disabled. Is there a way to pass the value from parent to child for the reference type: "External link". I am using SQL Server Datatools.

Answer 1

You can configure all child packages to use parent variables.

Do the following in the package control child thread:

• Right-click the desktop and select Package Configurations.
• Check the box next to “Enable package configurations.”
• Click "Add" and configure it as follows:
• Type of configuration: parent package variable.
• Parent variable: select the parent variable to pass to the child package.
• Click "Next"
• Select a value for the child variable. It should be the last in the objects column.
• Click "Next."
• Click Finish.
• Click "Close."

Answer 2

This is different from what you requested, but you can write the value to the table of the child package, which, in turn, will be restored and checked by the parent package after each child package is launched.