Package.Configurations Property

Reference

Definition

Namespace:: Microsoft.SqlServer.Dts.Runtime

Assembly:: Microsoft.SqlServer.ManagedDTS.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets the collection of configurations for the package. A package can have more than one configuration associated with it. This property is read-only.

public:
 property Microsoft::SqlServer::Dts::Runtime::Configurations ^ Configurations { Microsoft::SqlServer::Dts::Runtime::Configurations ^ get(); };

public Microsoft.SqlServer.Dts.Runtime.Configurations Configurations { get; }

member this.Configurations : Microsoft.SqlServer.Dts.Runtime.Configurations

Public ReadOnly Property Configurations As Configurations

Property Value

Configurations

The collection of configurations for the package.

Examples

The following example loads a sample package, and then returns a count of the number of configurations associated with the package.

class PackageTest  
    {  
        static void Main(string[] args)  
        {  
            // The variable pkg points to the location of the  
            // ExecuteProcess package sample installed with the  
            // samples.  
            string pkg = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";  

            Application app = new Application();  
            Package p = app.LoadPackage(pkg, null);  

            int n = p.Configurations.Count;  
            Console.WriteLine("Number of configurations = " + n);  
        }  
    }

Class PackageTest  
        Shared  Sub Main(ByVal args() As String)  
            ' The variable pkg points to the location of the  
            ' ExecuteProcess package sample installed with the  
            ' samples.  
            Dim pkg As String =  "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx"   

            Dim app As Application =  New Application()   
            Dim p As Package =  app.LoadPackage(pkg,Nothing)   

            Dim n As Integer =  p.Configurations.Count   
            Console.WriteLine("Number of configurations = " + n)  
        End Sub  
End Class

Remarks

Each configuration allows you to set a package variable from an external source, such as from a configuration file, environment variable, or registry entry. For more information about package configuration, see Create Package Configurations.

Applies to

共用方式為