asked
Don't see package from Execute Package Task Editor
Hi, Windows 2008 and SQL 2012, I am trying to call a package from Execute Package Task Editor; but I am not able to see other packages deployed in SSISDB/Project/MyProj folder with SSISDB connection. Something I missed? Thanks. Chris
What you mean by "I'm not able to see other packages". Does it means, you see some?.
Thanks for the help. I am able to see the list of deployed packages under Integration Services Catalog\SSISDB\MySystem\Project folder. When I tried to migrade existing 2005 SSIS, a package call child one. In 2005 with connection to MSDB, I was able to add child package from Package Tasks Editor; but cannot find/add in 2012. Chris
In Case you are developing a SSIS Project in Project Deployment model, then in the Execute Package Task you have two options how to execute packages: 1. **External Reference** - This can reference a package located in File System or in SQL Server - but those are packages deployed into MSDB in Package Deployment Model. 2. **Project Reference** - Here you can choose other package from your project to execute. In this way you execute packages in the Project deployment mode. You do not browse the SSIS Integration Catalog. Also Package from one project cannot execute a package from other project. You can execute packages from the same project.
HI Chris, yes, if you would like to execute a package as Project Reference, you have to add it to the project in the Solution Explorer.
15 People are following this question.
