Call a SSIS package inside another - Part 2

Introduction

In the previous article we saw how we can call a SSIS package inside another where we called a package from the file system.

http://www.dotnetfunda.com/articles/article1236-call-a-ssis-package-inside-another-.aspx

Now thru this article we will try to call a SSIS package that is stored in SQL Server in another package.

So lets start and see how it works.

Start MS BI Development Environment, Select and Integration services project.

Drag drop a Execute Package Task on to the package as shown.

Double click on the task to configure as shown, Select the location to be SQL Server

Select the Connection to be your server where you have your SSIS package resides

Click on Package to select the package from the list of packages in the SQL Server.

Click OK to complete configuring the Execute package task.

Finally Click ok to close the editors

Thats it.. Execute the package and see the result

Since the package that we called from this package here is Conditional Split in SSIS that we created earlier.

We will get the same result that we got there i.e. two separate files will be created. Please refer to this link for details.

http://www.dotnetfunda.com/articles/article1214-conditional-split-in-ssis-.aspx

Simple... Hope you all like this article..