Controlling one SSIS package from another

Individual packages: Flat File Source - > Ole DB Destination

To get the Parent Package Variable value:

Configurations:

i.Create a variable var_dir

ii.Right Click: Choose "Package Configuration" : choose : Parent Package Variable: map to var_dir

iii.Expression: concatenate var_dir + file name

Note:

i.In Parent Package: a variable is defined like: var_file_dir c:\data\

where all the text files are there that need to be loaded

The Parent Package: Which is calling these 3 Packages.

i.3 variables are declared for 3 packages which is boolean and value "True"

This is used to: make the individual package "Disabled" in the beginning.

Configuration to disable: Expression below "Disable"

ii.Package first runs a script task and read the variable values containing just directory information.

iii.File Exist task checks if file are there or not , if there then set the boolean value "True" , False

, that way enables the packages to run.

Exploring