'SSIS: I don't see the package configuration wizard

Using SQLServer 2012 Enterprise, I don't see "Package Configuration Wizard" in SSIS when I do a right click in Control Flow tab. I can see all the other items (Log, Digital Signing...).

Here are info about my install:

Microsoft Visual Studio 2010
Version 10.0.40219.1 SP1Rel
Microsoft .NET Framework
Version 4.0.30319 SP1Rel
Professional

SQL Server Analysis Services   
Concepteur Microsoft SQL Server Analysis Services 
Version 11.0.2100.60

SQL Server Integration Services   
Concepteur Microsoft SQL Server Integration Services
Version 11.0.2100.60

SQL Server Reporting Services   
Concepteurs Microsoft SQL Server Reporting Services
Version 11.0.2100.60
ssissql-server-2012


Solution 1:[1]

It is still available, but hidden because configuring a package is a little different in the 2012 Project Deployment Model. But if you open a package, right-click in the Control Flow tab, click on the Properties of the package, then you will find a Configurations property under Misc. Old package configurations

Solution 2:[2]

  1. On the Project Menu, click Convert to Package Deployment Model.
  2. Click OK on the warning prompt and, once the conversion is complete, click OK on the Convert to Package Deployment Model dialog.
  3. Click the background of the Control Flow tab in SSIS Designer.
  4. On the SSIS menu, click Package Configurations.
  5. In the Package Configurations Organizer dialog box, select Enable Package Configurations, and then click Add.

See this link >> http://msdn.microsoft.com/en-IN/library/ms166598.aspx

Solution 3:[3]

Thank you for providing below information (I was lost how to find this option):

It is still available, but hidden because configuring a package is a little different in the 2012 Project Deployment Model. But if you open a package, right-click in the Control Flow tab, click on the Properties of the package, then you will find a Configurations property under Misc.

Solution 4:[4]

enter image description hereIf you ran the option "covert to deployment model" and still do not see the "package configuration" option under Menu-> SSIS then you need to follow steps below

  1. right click project and click on "properties"
  2. you would see two side pane, left side pane select option "Deployment" then right side you would see option "Create deployment utility" and set this option to TRUE
  3. Click on OK and go back to the package, you would see "Package configuration" would be available
  4. shortcut to "package configuration" is right click on empty space within package control flow and select from menu.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Umberto
Solution 2
Solution 3 Mohammad J Qureshi
Solution 4 ShahidAliK

Related Questions