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
Last activity: Apr 14, 2023, 12:25 PM