Home Library Learn Downloads Support Community
Sign in | United States - English | |
This topic has not yet been rated - Rate this topic

ConnectionManagerBase Class

Represents the abstract base class for connection managers.

System.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

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
C#
C++
F#
JScript
VB
Copy 
public abstract class ConnectionManagerBase : DtsObject

The ConnectionManagerBase type exposes the following members.

  Name Description
Protected method ConnectionManagerBase Initializes a new instance of the ConnectionManagerBase class.
Top
  Name Description
Public property ConnectionString Gets or sets the connection string for the connection.
Public property ProtectionLevel Gets or sets a value, by using the DTSProtectionLevel enumeration, that enforces how the connection controls sensitive information.
Public property Scope Gets the DTS connection manager scope for this ConnectionManagerBase object.
Public property SupportsDTCTransactions Returns a Boolean that indicates if the connection supports Microsoft Distributed Transaction Coordinator (MS DTC) transactions.
Public property Version Returns the version of this connection manager.
Top
  Name Description
Public method AcquireConnection Creates an instance of the connection type.
Public method CanUpdate Gets or sets a Boolean that determines whether a connection manager supports upgrading the connection XML to a newer version.
Public method Equals Determines whether two object instances are equal. (Inherited from DtsObject.)
Protected method Finalize (Inherited from Object.)
Public method GetHashCode Returns the hash code for this instance. (Inherited from DtsObject.)
Public method GetType (Inherited from Object.)
Protected method MemberwiseClone (Inherited from Object.)
Public method ReleaseConnection Frees the connection established during AcquireConnection. Called at design time and run time.
Public method SetQualifier Changes a qualifier on the connection manager after the connection manager has been created, but before it is run.
Public method ToString (Inherited from Object.)
Public method Update Updates the XML persisted by a previous version of the connection manager.
Public method Validate Validates the connection and returns an enumeration that indicates success or failure.
Top

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.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)