The Execute Package task in SSIS allows users to call packages that are part of the Same Project, File system, and SQL Server. It extends the enterprise capabilities of Integration Services by allowing packages to execute other packages.
The Execute Package Task is used with a number of purposes:
- Running packages;
- Breaking down a complex package workflow, Which makes them easier to read, test, and maintain;
- Reusing parts of packages. Other packages can reuse parts of a package workflow;
- Grouping work units;
- Controlling package security. By separating a package into multiple packages, you can provide a greater level of security, because you can grant an author access to only the relevant packages;
- Extending transactions;
- Propagating Logging Details.
- Reference Type – this tells the task where the package that we want to run, exists;
- Project Reference is for packages that exist within the project;
- External Reference is for packages that have already been deployed to a server that you would want to reuse;
- PackagesNameFromProjectReference – will allow us to select a package that exists within the project, when the Project Reference type is selected. This will be a child project;
- If the user selects External Reference, the Editor will ask the user to enter a Location, a Connection, and a Package Name for the package the user is trying to access;
- Selecting the SQL Server location, will ask for a Connection and the PackageName, which can be written or selected by clicking on the ellipsis (…).
- Selecting the File System location, will ask for a Connection and will display the name of the package below.
- Password – will let you enter a password for the package you’re trying to execute, in case it is password protected;
- ExecuteOutOfProcess – switching this to true will spawn a separate process to run this package outside of the process that is being used to run the Parent.dtsx package.
Parameter Bindings Tab
Child package parameter – this sets the name of the parameter that we will be receiving the passed value. Change NewParameterName to Process_MemberFileName.
Binding parameter or Variable: This drop down contains any package parameters or variables accessible to our current package that we will be passing values from.