Thursday 2 December 2021

For those of you that have come up against the problem in SSIS packages where you cannot use an Execute Package Task to run a Package that is stored in the SSISDB then here is a solution.

Instead of using an Execute Package Task you will need to use an Execute SQL Task instead.

Firstly you will need to create the following Stored Procedure on whichever database you wish to that resides on the same SQL Server as the SSISDB.

Then in your controller parent SSIS Package use an Execute SQL Task and run the following SQL Statement: Amending the parameters as necessary.