Package.EnableConfigurations Property
Indicates whether the package loads configurations.
Espacio de nombres: Microsoft.SqlServer.Dts.Runtime
Ensamblado: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
Sintaxis
'Declaración
Public Property EnableConfigurations As Boolean
public bool EnableConfigurations { get; set; }
public:
property bool EnableConfigurations {
bool get ();
void set (bool value);
}
/** @property */
public boolean get_EnableConfigurations ()
/** @property */
public void set_EnableConfigurations (boolean value)
public function get EnableConfigurations () : boolean
public function set EnableConfigurations (value : boolean)
Valor de propiedad
true indicates that configuration files are loaded when the package is loaded.
Notas
If this property is set to false, the persisted values in the package will be used, rather than overwritten by the loaded configurations.
When deploying the package, you can set this to false with the last configuration. Then, when the package is first run after deployment, the package values will be overwritten once by the configuration values. For more information about configurations used by a package, see Crear configuraciones de paquetes.
Ejemplo
The following example creates a new package, and then sets the EnableConfigurations to true, as well as the ExportConfigurationFile property. The example then adds a new configuration to the package and sets the value of several properties.
Package pkg = new Package();
pkg.EnableConfigurations = true;
pkg.ExportConfigurationFile("conf.xml");
// Create a variable object and add it to the
// package Variables collection.
Variable varPkg = pkg.Variables.Add("var", false, "", 100);
varPkg.Value = 1;
string packagePathToVariable = varPkg.GetPackagePath();
Configuration config = pkg.Configurations.Add();
config.ConfigurationString = "conf.xml";
config.ConfigurationType = DTSConfigurationType.ConfigFile;
config.PackagePath = packagePathToVariable;
// more code here.
Dim pkg As Package = New Package()
pkg.EnableConfigurations = True
pkg.ExportConfigurationFile("conf.xml")
' Create a variable object and add it to the
' package Variables collection.
Dim varPkg As Variable = pkg.Variables.Add("var",False,"",100)
varPkg.Value = 1
Dim packagePathToVariable As String = varPkg.GetPackagePath()
Dim config As Configuration = pkg.Configurations.Add()
config.ConfigurationString = "conf.xml"
config.ConfigurationType = DTSConfigurationType.ConfigFile
config.PackagePath = packagePathToVariable
' more code here.
Seguridad para subprocesos
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Plataformas
Plataformas de desarrollo
Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.
Plataformas de destino
Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.
Vea también
Referencia
Package Class
Package Members
Microsoft.SqlServer.Dts.Runtime Namespace