Advanced Execute Package

Parent Previous Next


Advanced Execute Package Task


The "Advanced Execute Package Task" is used to execute child packages within an SSIS package from either a local file or a package stored on SQL Server. A unique feature of the "Advanced Execute Package Task" is the ability to map variables between the executing package and the child package.



 Child Package Location - There are two choices for choosing a child package location:

o  File System - A local file on the executing machine

o  SQL Server - A package stored on a SQL Server

 Connection Manager - Only available if SQL Server is selected in the Child Package Location. You may select either an ADO or OLEDB connection manager

 Child Package Path - Depending on the location choice, the package path will either point to a local file or the path where it is stored on a SQL Server

 Password - If the child package is password protected you must enter the password here

 Catalog Environment - Users can select environment variables created within SQL Server

 Execution Mode (Catalog execution only) - users define how the child package will be executed by selecting one of the following:

o  In Process - (Default) Downloads the package, creates a local ispac project, and executes it locally.

o  Out of Process - (Preferred) Executes the package on the server. This is the most common use because local resources are not used to run the package. You cannot read any parameters after execution. Parameters can only be written to.

 Run In 32 Bit (Catalog execution with Out of Process mode only) - Executes the child package in 32 bit mode.


For more information about execution modes, please see the  Advanced Execute Package FAQ.


Variable Mappings


You have three options for mapping variables from your package to the child package called "Assignment Directions".


 Read Variable Form Child Package - This mapping direction will read the value of the variable selected in the "Child Package Variable" and assign the value to the variable in the "Parent Package Variable". The value of the variable will be read after the execution of the child package has occurred.

 Write Variable to Child Package - This mapping direction will write the variable selected in "Parent Package Variable" and assign the value to the variable selected in the "Child Package Variable". The value of the variable will be written before execution of the child package.

 Read and Write Variable From Child Package - The mapping direction will write the variable value selected in "Parent Package Value" and assign the value to the variable selected in the "Child Package Variable" before execution occurs and then will read the value of the variable selected in the "Child Package Variable" and assign the value to the variable selected in the "Parent Package Variable" after execution has occurred.


Data Type Matching of Variables


The data type of the mapped variables must be the same. For instance if you choose a string variable in the "Child Package Variable", only string variables from your package will be shown in the "Parent Package Variable" drop-down.