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
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 change the Name as 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 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.
Click on it to select the package. If the Inner Join package secured with a password (In general, Yes), provide the password.
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 calling Inner Join Package. After this Transformation is successful, the Execute Package Task will execute.
It seems our Execute Package Task not thrown any errors. Let us open the SQL Server Management Studio and check the result.
Well, we successfully called the package present in the same project using SSIS Execute Package Task Project Reference.