question

Chris 2 avatar image
Chris 2 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
sql-server-2012
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

What you mean by "I'm not able to see other packages". Does it means, you see some?.
0 Likes 0 ·
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
0 Likes 0 ·

1 Answer

·
Pavel Pawlowski avatar image
Pavel Pawlowski answered
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.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hi Pavel, Thanks for the help. Do I first have to add child package to solution Explorer\SSIS Packages? When I tried to do so with SSIS package Store and SQL Server, it shows old MSDB. I cannot find packages under SSISDB. Chris
0 Likes 0 ·
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.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.