visual-studiovisual-studio-2010ssissql-server-2012

I don't see the SSIS package configuration wizard in Visual Studio 2010


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

Solution

  • 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