How to read/write variable value from child/parent package in SSIS?
Changing value of child package variable was easily possible in DTS using “Execute DTS Package Task” settings called inner/outer variables. But unfortunately this is not directly supported in SSIS if you using “Execute SSIS Package Task”. However you can use VB.net code inside script task to read/write child package variable. There is another way to read parent package variable in SSIS is “Configurations”. The following two sections illustrate both techniques. Read parent package variable from child package (Using Parent Variable Configuration) The Parent Variable Configuration feature of SSIS allows variables from a parent package to be inherited by a child package. This is different than the SSIS’ predecessor, DTS, where variables were pushed down from the parent package to the child package. In SSIS the child package requests the variable by name from the parent package, allowing the variable to be inherited from any calling parent package that uses the Execute Package task to call
