Export (0) Print
Expand All

Connections::Item Property

Gets a ConnectionManager object from the Connections collection.

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

public:
property ConnectionManager^ default[Object^ index] {
	ConnectionManager^ get (Object^ index);
}

Parameters

index
Type: Object
The name, identity, ID, or index of the ConnectionManager object to return.

Property Value

Type: Microsoft.SqlServer.Dts.Runtime::ConnectionManager
A ConnectionManager object from the collection.

If the call to the Contains method returns true, you can access the specified element in the collection using the syntax Connections[index]. If the Contains method returns false, this property throws an exception. In C#, this property is the indexer for the Connections class.

The following code sample retrieves an item from the collection using two methods. The first method uses the conns[0] syntax to retrieve the whole object located in the first position of the collection and put it in the myConnMgr variable. You can now retrieve all properties from the myConnMgr as usual. The second method retrieves a specific property from the first object in the collection using the conns[0].<property> syntax.

No code example is currently available or this language may not be supported.

Sample Output:

The ID of the first connection info is: {B52C0D78-5402-4544-BFEC-2BE203900C91}

The Name of the first connection info is: Create_Execute_Process_Dest.sql

Community Additions

ADD
Show:
© 2014 Microsoft