Execute Package Task

          Using "Execute Package Task", we can call other SSIS packages in to current package.Current package we can call it as 'Parent package', other packages we can call as 'Child packages'. If we run the parent package, child packages also will execute along with parent.

Example:

• In 'Control Flow', drag and drop "Execute Package Task" from Toolbox.

• Edit the "Execute Package Task"
• Go to "Packages" section.
• Select SSIS package location from the "Location" drop down list.

          My SSIS package is available in "File System", so i am going to select "File System" option.

• Select "New Connection" Option from "Connection" drop down list.

• "File Connection Manager Editor" Window will open.
• Browse the Required SSIS package.

• Click on 'File Connection Manager Editor' "OK" button.

 

•  Click on "Execute Package Task Editor" OK button.
• Package is ready to execute.