21

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
Francois
  • 10,730
  • 7
  • 47
  • 80

5 Answers5

46

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

Umberto
  • 2,011
  • 1
  • 23
  • 27
Joost
  • 1,873
  • 2
  • 17
  • 18
23

The 2012 release of SSIS introduces a new model for configuration and deployment called the Project deployment model. As part of that change, the old way of doing configuration (environment, xml, parent package, registry and table) is not an option. In the project deployment model, you get parameters and environments. Thus far, I think it's going to be an improvement.

Fear not though, the classic way of doing things is still available. Right click on your project and select Convert to Package Deployment Model

enter image description here

Jeff
  • 12,555
  • 5
  • 33
  • 60
billinkc
  • 59,250
  • 9
  • 102
  • 159
  • Is there a link to the new way of doing things? – PeterX Sep 05 '13 at 02:11
  • Anything in particular you are looking for @PeterX – billinkc Sep 05 '13 at 02:26
  • All good - @Joost's answer below has helped - choosing `Configurations` via the Properties pane. – PeterX Sep 05 '13 at 02:58
  • @billinkc you might wish to update this answer to reflect that package-level config files are in fact still available, even in the Project Deployment Model (as per Joost's answer). You just have to find the hidden place to go to turn them on. – criticalfix Mar 24 '14 at 17:42
1
  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

Beginner
  • 670
  • 12
  • 25
0

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.

Mohammad J Qureshi
  • 11
  • 1
0

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.
ShahidAliK
  • 30
  • 7