SSIS Execute Package Task Project Reference

In this article, we are going to show you how to Execute Packages present in the Same Project using SSIS Execute Package Task Project Reference.

In this example, we are going to execute, Inner Join Package present in the same project using the Execute Package Task. We already explained this package in Performing Inner Join Using Merge Join Transformation article.

You can see from the below screenshot, [Inner Join Using Merge Join Transformation] table is empty. If not, Please truncate the table using T-SQL or add Execute SQL Task.

SSIS Execute Package Task Project Reference 0

SSIS Execute Package Task Project Reference

Drag and drop the Execute Package Task from the toolbox to the Control Flow Region.

SSIS Execute Package Task Project Reference

Double click on the Execute Package Task to configure the package. In the General tab, we can change the name and description. For this SSIS demo, we change the Name as Execute Package Task from Project Reference.

SSIS Execute Package Task Project Reference 1

Click on the package tab to configure the package location and connection string

Execute Packages in SQL Server using SSIS Execute Package Task

In this example, We are executing the package present in the same project. So, Please Keep the ReferenceType as Project Reference. Please refer Execute Packages in SQL Server using SSIS Execute Package Task article for calling packages in SQL Server and Execute Packages in File System using SSIS Execute Package Task for calling packages in File System

Now we have to select the dtsx package from the project so, select the PackageNameFromProjectReference option. It will show you all the packages available in the current project. From the below screenshot you can observe, we are selecting the INNER JOIN package from the list.

SSIS Execute Package Task Project Reference 2

Click on it to select the package. If the Inner Join package secured with a password (In general, Yes), provide the password.

SSIS Execute Package Task Project Reference 3

Click ok to finish configuring the Execute Package Task. Let us Run the Package and see whether we successfully called the package present in the same project using SSIS Execute Package Task or not.

SSIS Execute Package Task Project Reference 4

From the above, you can observe that our Execute Package Task is calling Inner Join Package. After this Transformation is successful, the Execute Package Task will execute.

SSIS Execute Package Task Project Reference 5

It seems our Execute Package Task not thrown any errors. Let us open the SQL Server Management Studio and check the result.

SSIS Execute Package Task Project Reference 6

Well, we successfully called the package present in the same project using SSIS Execute Package Task Project Reference.