Configuration - SQL Server Integration Services Design Patterns - page 408

You can use Visual Studio configurations to create multiple sets of parameter values
within SSDT-BI. Switching between configurations allows you to easily change para-
meter values during development and also allows you to build multiple versions of
your project deployment file with different default parameter values. Visual Studio
configurations are a way for developers to maintain their own settings in mul-
tideveloper or team environments.
When you first create a project within SSDT-BI, you will have a default configura-
tion called Development . You can create additional configurations from the Config-
uration Manager dialog (shown in Figure 17-8 ). You can launch the Configuration
Manager dialog from the Solution Configurations combo box on the Standard toolbar
or by right-clicking on the project node in the Solution Explorer, selecting Properties,
and clicking the Configuration Managers button. To create a new configuration, select
the <New...>option from the Active Solution Configuration dropdown.
Figure 17-8 . Visual Studio configurations can be managed from the Configuration Manager dialog
To add a parameter to a configuration, click the Add Parameters to Configurations
button on the package Parameters tab. Figure 17-9 shows the Manage Parameter Values
dialog that will be displayed when you add package parameters to configurations.