The Execute Package Task in SSIS allows us to call other packages present in SQL Server, File System and Packages present in the same project as a part of its execution. 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 Execute Package Task. We already explained about this package in our previous article so, Please refer Performing Inner Join Using Merge Join Transformation article for understanding the package.
You can see from 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 toolbox to Control Flow Region.
Double click on the Execute Package Task to configure the package. In the General Tab we can change the name and provide useful description. As of now, we changes the Name as Execute Package Task from Project Reference and left the description as it is.
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 INNER JOIN package from the list.
Click on it to select the package. If the Inner Join package is secured with password (In general Yes) then provide appropriate 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 then Execute Package Task will execute.
It seems our Execute Package Task is 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.
Thank You for Visiting Our Blog