Hello everyone,

I'm a bit confused with SSIS catalog (2014).

My question is:

The package \Project_Test_1\Flow.dtsx should start the following packages:

1- \Project_Test_1\Staging_A.dtsx
2- \Project_Test_1\Staging_B.dtsx
3- \Project_Test_2\Staging_C.dtsx

I would like to know how the Flow.dtsx (Project_Test_1) can access package Staging_C.dtsx (Project_Test_2) within Catalogs.

When I was using Integration Services in SQL Server 2008 R2, I was working with Flow call packages on MSDB. However, I don't know how to call the same way to packages on Catalog.

Any help would be much appreciated.

Hi Lorrane,

I do not think you can access a package from a different project under the catalog, either use a SQL Server Agent Job to orchestrate the execution, or do it programmatically through a script.

Yeah, the external reference option in the execute package task would have been great if it allowed you to reference a package in another project.  Anyway, check out the link below on a similar topic.

http://microsoft-ssis.blogspot.com/2014/06/ssis-2012-execute-package-task-external.html

Hi Lorrane,

If I understand correctly, you want to execute a package from SSIS Catalog in another package.

In SQL Server Integration Services, the Execute Package task can run a child package from the project with Project Reference, can also run packages stored in the SQL Server MSDB database and packages stored in the file system with External Reference. There is no such feature that support run the package from SSISDB database in the Execute Package task. For more details, please see:
https://technet.microsoft.com/en-us/library/ms137609(v=sql.120).aspx

In order to execute a package from SSIS Catalog in another package, we can use the Execute SQL Task with system stored procedure:
https://msdn.microsoft.com/en-us/library/jj820152.aspx?f=255&MSPPError=-2147217396

Thanks,
Katherine Xiong