Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSIS: I don't see the package configuration wizard

Tags:

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
like image 690
Francois Avatar asked Jul 04 '12 08:07

Francois


People also ask

How do I enable package configurations in SSIS?

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.

Where is the config file for SSIS package?

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.

How many types of package configurations are available in SSIS?

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.


2 Answers

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

like image 28
billinkc Avatar answered Sep 18 '22 13:09

billinkc


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

like image 114
Joost Avatar answered Sep 20 '22 13:09

Joost