DTSConfigurationType Enumeration
Specifies the ways that a configuration for a package can be saved.
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
| Member name | Description | |
|---|---|---|
| ConfigFile | Specifies that the configuration is stored in a configuration file. In the SSIS Package Configuration Wizard, the Configuration File Name column is where you specify the location and name of the configuration file that the wizard generates. | |
| EnvVariable | Specifies that the configuration is stored in an environment variable. | |
| IConfigFile | Specifies that the configuration is stored in an environment variable that contains the information about configuration flat file. | |
| IIniFile | This member is reserved for future use. | |
| IniFile | This member is reserved for future use. | |
| IParentVariable | Specifies that the configuration information is stored in an environment variable that contains the information about the package variable. | |
| IRegEntry | Specifies that the configuration information is stored in an environment variable that contains the information about the registry entry. | |
| ISqlServer | Specifies that the location of the configuration information is stored in an environment variable that contains information about the SQL Server . | |
| ParentVariable | Specifies that the configuration information is stored in a package variable. | |
| RegEntry | Specifies that the configuration information is stored in a registry entry. | |
| SqlServer | Specifies that the configuration is stored in the SQL Server msdb database. This field is constant. |
Integration Services supports many different ways of specifying configurations for a package. For more information, see Create Package Configurations.
The following code example creates a package, enables configurations, and enables the export of the configuration file. It adds a new Configuration to the package Configurations collection, and sets several properties on the configuration, including the ConfigurationType, which uses this enumeration. After saving and reloading the package, the configuration properties are displayed.
Sample Output:
The value of variable var = 1
ConfigurationString is conf.xml
ConfigurationType is ConfigFile
CreationName is
Description is My configuration description
Assigned ID is {9CF65E37-0833-44CD-A99D-EBFE38FAB31B}
Name is {9CF65E37-0833-44CD-A99D-EBFE38FAB31B}
Package Path is \Package.Variables[::var]