Configuration Class

Article
12/03/2008

Represents a configuration class that contains information about how a package is configured. This class cannot be inherited.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Syntax

'Declaration
Public NotInheritable Class Configuration
    Inherits DtsObject
    Implements IDTSPersist, IDTSName

public sealed class Configuration : DtsObject, IDTSPersist, IDTSName

public ref class Configuration sealed : public DtsObject, IDTSPersist, IDTSName

public final class Configuration extends DtsObject implements IDTSPersist, IDTSName

public final class Configuration extends DtsObject implements IDTSPersist, IDTSName

Remarks

Configurations are useful when deploying packages to many different servers, and make it easy to move packages from development to production environments.

You can use variables to update packages dynamically, which enables you to customize package functionality and adapt packages to the environments in which they run. To update package properties at run time by using variables, map variables to package object properties, create configurations for the variables, deploy the configurations with the package, and then update the variable values in the configuration file to suit the new environment. At run time, the package automatically uses the updated values. This flexibility is useful when the packages that you have deployed connect to different servers, run different SQL statements, or run different child packages. For more information, see Creating Package Configurations and Using Variables in Packages.

Inheritance Hierarchy

System.Object
Microsoft.SqlServer.Dts.Runtime.DtsObject
Microsoft.SqlServer.Dts.Runtime.Configuration

Thread Safety

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.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Share via