SSIS 2012 pass values from child package to parent with project deployment model
ssis
Solution
I have spoken with a couple experts about this there is no NATIVE way of doing this in SSIS. I did see a mention about a way of doing this which is effectively a hack in a script task, but anyone reading this store results from your variables into a table and reference from there. Parameter binding on the execute package task is currently a ONE way street Parent --> Child.
Problem
i'm using the new project deployment model. I have a master package called ETL. The first thing my ETL package does is run a package called get SFTP files as shown. Within Get SFTP files a foreach loop gets the ClientID. HOW do i pass this value back to the parent package ETL??? To do inserts etc.