Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

ConnectionManagerBase Class

Represents the abstract base class for connection managers.

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
public abstract class ConnectionManagerBase : DtsObject

The ConnectionManagerBase type exposes the following members.

  NameDescription
Protected methodConnectionManagerBaseInitializes a new instance of the ConnectionManagerBase class.
Top
  NameDescription
Public propertyConnectionStringGets or sets the connection string for the connection.
Public propertyProtectionLevelGets or sets a value, by using the DTSProtectionLevel enumeration, that enforces how the connection controls sensitive information.
Public propertyScopeGets the DTS connection manager scope for this ConnectionManagerBase object.
Public propertySupportsDTCTransactionsReturns a Boolean that indicates if the connection supports Microsoft Distributed Transaction Coordinator (MS DTC) transactions.
Public propertyVersionReturns the version of this connection manager.
Top
  NameDescription
Public methodAcquireConnectionCreates an instance of the connection type.
Public methodCanUpdateGets or sets a Boolean that determines whether a connection manager supports upgrading the connection XML to a newer version.
Public methodEqualsDetermines whether two object instances are equal. (Inherited from DtsObject.)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCodeReturns the hash code for this instance. (Inherited from DtsObject.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodReleaseConnectionFrees the connection established during AcquireConnection. Called at design time and run time.
Public methodSetQualifierChanges a qualifier on the connection manager after the connection manager has been created, but before it is run.
Public methodToString (Inherited from Object.)
Public methodUpdateUpdates the XML persisted by a previous version of the connection manager.
Public methodValidateValidates 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)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.