In this article, we will show you how to Execute Packages present in the Same Project using SSIS Execute Package Task Project Reference.
In this example, we will execute the Inner Join Package present in the same project using the Execute Package Task. We already explained this package in the Performing Inner Using Merge Join Transformation article.
The screenshot below shows the [Inner Join Using Merge Join Transformation] table is empty. If not, truncate the table using T-SQL or add an Execute SQL Task.
SSIS Execute Package Task Project Reference
Drag and drop the Execute Package Task from the toolbox to the Control Flow Region.
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 changed the Name to Execute Package Task from Project Reference.
Click on the package tab to configure the package location and connection string.
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 article for calling packages in SQL Server and Execute Packages in File System 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 screenshot below, you can observe we are selecting the INNER JOIN package from the list.
Click on it to select the package. Provide the password if the Inner Join package is secured with a password (In general, Yes).
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.
From the above, you can observe that our Execute Package Task is called the Inner Join Package. After this Transformation is successful, the Execute Package Task will execute.
It seems our Execute Package Task has not thrown any errors. Let us open the Management Studio and check the result.
We successfully called the package present in the same project using SSIS Execute Package Task Project Reference.
