ConnectionManagerBase Class
SQL Server 2014
Represents the abstract base class for connection managers.
Object
Microsoft.SqlServer.Dts.Runtime.DtsObject
Microsoft.SqlServer.Dts.Runtime.ConnectionManagerBase
Microsoft.SqlServer.Dts.ManagedConnections.MSMQConn
Microsoft.SqlServer.Dts.ManagedConnections.SMOServerConn
Microsoft.SqlServer.Dts.ManagedConnections.SMTPConn
Microsoft.SqlServer.Dts.ManagedConnections.WMIConn
Microsoft.SqlServer.Dts.Runtime.DtsObject
Microsoft.SqlServer.Dts.Runtime.ConnectionManagerBase
Microsoft.SqlServer.Dts.ManagedConnections.MSMQConn
Microsoft.SqlServer.Dts.ManagedConnections.SMOServerConn
Microsoft.SqlServer.Dts.ManagedConnections.SMTPConn
Microsoft.SqlServer.Dts.ManagedConnections.WMIConn
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
The ConnectionManagerBase type exposes the following members.
| Name | Description | |
|---|---|---|
 | ConnectionManagerBase | Initializes a new instance of the ConnectionManagerBase class. |
| Name | Description | |
|---|---|---|
| ConnectionString | Gets or sets the connection string for the connection. |
| ProtectionLevel | Gets or sets a value, by using the DTSProtectionLevel enumeration, that enforces how the connection controls sensitive information. |
| Scope | Gets the DTS connection manager scope for this ConnectionManagerBase object. |
| SupportsDTCTransactions | Returns a Boolean that indicates if the connection supports Microsoft Distributed Transaction Coordinator (MS DTC) transactions. |
| Version | Returns the version of this connection manager. |
| Name | Description | |
|---|---|---|
| AcquireConnection | Creates an instance of the connection type. |
| CanUpdate | Gets or sets a Boolean that determines whether a connection manager supports upgrading the connection XML to a newer version. |
| Equals | Determines whether two object instances are equal. (Inherited from DtsObject.) |
| Finalize | (Inherited from Object.) |
| GetHashCode | Returns the hash code for this instance. (Inherited from DtsObject.) |
| GetType | (Inherited from Object.) |
| MemberwiseClone | (Inherited from Object.) |
| ReleaseConnection | Frees the connection established during AcquireConnection. Called at design time and run time. |
| SetQualifier | Changes a qualifier on the connection manager after the connection manager has been created, but before it is run. |
| ToString | (Inherited from Object.) |
| Update | Updates the XML persisted by a previous version of the connection manager. |
| Validate | Validates the connection and returns an enumeration that indicates success or failure. |
You create a managed connection manager by deriving a managed class from the ConnectionManagerBase, and then marking it with DtsConnectionAttribute attribute.
When creating a managed connection manager, you must ensure that the threading model is Both for the connection manager to work properly with the Integration Services runtime.
Community Additions
ADD
Show:
