Package.Connections Property

Returns the collection of connection managers for the package.

命名空间: Microsoft.SqlServer.Dts.Runtime
程序集: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

语法

声明
Public ReadOnly Property Connections As Connections

public Connections Connections { get; }

public:
property Connections^ Connections {
    Connections^ get ();
}

/** @property */
public Connections get_Connections ()

public function get Connections () : Connections

属性值

A Connections collection.

备注

已更新的文本：2005 年 12 月 5 日

Connection managers provide tasks with a generic interface to the underlying data store, allowing for simpler task implementation. Use the AcquireConnection method of the ConnectionManager object to retrieve the necessary connection information from any of the connection manager objects in the collection.

The connection manager can be referenced by GUID or by name, and you can store the name of the connection manager in a configuration file. To reference the connection by name, use \Package.Connections[myConnection].ConnectionString, instead of using \Package.Connections[{9930DA64-A413-4286-9C66-74EDADB4F393}].ConnectionString.

For more information about connections and connection managers, see Integration Services 连接.

示例

The following example loads the UsingExecuteProcess package sample, and then retrieves the connections that are used by the package and displays some properties about the connections.

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

            Application app = new Application();
            Package p = app.LoadPackage(pkg, null);
            Connections conns = p.Connections;
            foreach (ConnectionManager cm in conns)
                Console.WriteLine("Name = " + cm.CreationName + ", HostType = " + cm.HostType);
        }

Shared  Sub Main(ByVal args() As String)
            ' The variable pkg points to the location
            ' of the ExecuteProcess package sample 
            ' that is installed with the samples.
            Dim pkg As String =  "C:\Program Files\Microsoft SQL Server\90\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 conns As Connections =  p.Connections 
            Dim cm As ConnectionManager
            For Each cm In conns
                Console.WriteLine("Name = " + cm.CreationName + ", HostType = " + cm.HostType)
            Next
End Sub

Sample Output:

Name = FILE, HostType = ConnectionManager

Name = OLEDB, HostType = ConnectionManager

Name = OLEDB, HostType = ConnectionManager

线程安全

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.

平台

开发平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

Package Class
Package Members
Microsoft.SqlServer.Dts.Runtime Namespace