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
Enable package configurationsSelect the background of the Control Flow tab in SSIS Designer. On the SSIS menu, select Package Configurations. In the Package Configurations Organizer dialog box, select Enable Package Configurations and then select Add.
Procedure: Open the completed SSIS package and click on the Control flow tab if not already selected. Right-click on a blank area in the control flow work area, then click on Package configurations. Click on the Add button to start creating a configuration file.
Solution. SSIS provides several options for handling package configuration values such as environment variables, XML files, registry settings, and a table in a SQL Server database.
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
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With