ConnectionManager::Properties Property

 

Gets a collection of property objects for the ConnectionManager. This is the method of accessing the properties of the specific connection that is being hosted by the connection manager. This property is read-only.

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

public:
property DtsProperties^ Properties {
	virtual DtsProperties^ get() sealed;
}

Property Value

Type: Microsoft.SqlServer.Dts.Runtime::DtsProperties^

A DtsProperties collection that contains the properties specific to that connection type.

All classes that inherit from the ConnectionManager contain the same properties and methods. However, each connection type has additional properties that are specific to that connection type. When you obtain a connection manager from the collection and iterate through the properties, all properties that are not found in the ConnectionManager class are properties that are specific to that connection. To set a property that is unique to the connection, but is not part of the ConnectionManager, such as the RetainSameConnection property found on several connections, use the following line of code:

ConnectionManager.Properties("RetainSameConnection") = True

For more information about the type of connections available, see Integration Services (SSIS) Connections.

The following code example obtains the Properties collection from the first connection manager in the Connections collection using the index syntax of [0]. The sample then writes the names of the properties found in the Properties collection.

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

Sample Output:

ConnectionString

CreationName

Description

ID

InitialCatalog

Name

Password

ProtectionLevel

RetainSameConnection

ServerName

SupportsDTCTransactions

UserName

Return to top
Show: