Sample Header Ad - 728x90

SSIS: Passing variable from child package to parent package

4 votes
2 answers
7555 views
I have an SSIS project consisting of many packages, including a Main_Flow package which executes the other packages in the desired order. The first package to be called from Main_Flow is Extract_Archive with a ForEach container that looks for zipped files. If one or more zip file exists, it extracts them in a location and marks a variable ArchiveFileFound to TRUE. Now back in the Main-Flow package, I would like the next step to be executed ONLY if the ArchiveFileFound from the Extract_Archive is set to TRUE. However that variable only exists in Extract_Archive. I've been looking for information on how to pass variables from one SSIS package to another but I cannot find a good practical and recommended example. Any thoughts?
Asked by pmdci (701 rep)
Oct 25, 2018, 01:02 PM
Last activity: Apr 14, 2023, 12:25 PM