Upgrade your Internet Experience
Microsoft.com
Welcome Sign in
Microsoft Developer Network
Click to Rate and Give Feedback
MSDN
MSDN Library
Collapse All/Expand All Collapse All
Other versions are also available for the following:
ConnectionManager Class

Provides the information that you must have to connect to a data source. All classes that inherit from the ConnectionManager contain the same properties and methods. The ConnectionManager class isolates the implementation details of the different connection types from the runtime. This enables the runtime to interact with each connection manager in a consistent and predictable manner. Connection managers contain a set of stock properties that all connections have in common, such as the Name, ID, Description, and ConnectionString. However, each connection type has additional properties that are specific to that connection type. These can be accessed through the Properties collection.This class cannot be inherited.

 Inheritance Hierarchy
System..::.Object
  Microsoft.SqlServer.Dts.Runtime..::.DtsObject
    Microsoft.SqlServer.Dts.Runtime..::.ConnectionManager

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
 Syntax
Visual Basic (Declaration) 
Public NotInheritable Class ConnectionManager _
    Inherits DtsObject _
    Implements IDTSObjectHost, IDTSPersist, IDTSName, IComponent,  _
    IDisposable, IDTSPropertiesProvider, IDTSPropertiesProviderEx, IDTSPackagePath, IDTSExecutionPath
Visual Basic (Usage) 
Dim instance As ConnectionManager
C# 
public sealed class ConnectionManager : DtsObject, 
    IDTSObjectHost, IDTSPersist, IDTSName, IComponent, IDisposable, 
    IDTSPropertiesProvider, IDTSPropertiesProviderEx, IDTSPackagePath, IDTSExecutionPath
Visual C++ 
public ref class ConnectionManager sealed : public DtsObject, 
    IDTSObjectHost, IDTSPersist, IDTSName, IComponent, IDisposable, 
    IDTSPropertiesProvider, IDTSPropertiesProviderEx, IDTSPackagePath, IDTSExecutionPath
F# 
[<SealedAttribute>]
type ConnectionManager =  
    class
        inherit DtsObject
        interface IDTSObjectHost
        interface IDTSPersist
        interface IDTSName
        interface IComponent
        interface IDisposable
        interface IDTSPropertiesProvider
        interface IDTSPropertiesProviderEx
        interface IDTSPackagePath
        interface IDTSExecutionPath
    end
JScript 
public final class ConnectionManager extends DtsObject implements IDTSObjectHost, IDTSPersist, IDTSName, IComponent, IDisposable, IDTSPropertiesProvider, IDTSPropertiesProviderEx, IDTSPackagePath, IDTSExecutionPath

The ConnectionManager type exposes the following members.

 Properties
  NameDescription
Public propertyConnectionStringGets or sets the connection string used to establish a connection to a data source.
Public propertyCreationNameReturns the string that is used by the runtime to create an instance of the ConnectionManager object and to add the object to the Connections collection. This property is read-only.
Public propertyDelayValidationGets or sets a Boolean that indicates whether package validation is delayed until the package runs.
Public propertyDescriptionGets or sets the description of the ConnectionManager object.
Public propertyHasExpressionsGets a value that indicates whether the connection manager has properties set through expressions.
Public propertyHostTypeGets an enumeration that describes the type of host that the connection is being used by. This property is read-only.
Public propertyIDGets the ID of the ConnectionManager. This property is read-only.
Public propertyInnerObjectReturns the specific connection type that was created. This property is read-only.
Public propertyNameGets or sets the name of the ConnectionManager object.
Public propertyOfflineModeGets or sets a value that indicates whether the connection manager is in offline mode.
Public propertyPropertiesGets 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.
Public propertyProtectionLevelGets or sets the level of encryption performed on sensitive data that is contained in the package.
Public propertyQualifierGets or sets the qualifier for the connection manager.
Public propertyScopeGets the scope of the connection manager.
Public propertySiteInfrastructure. Gets or sets the site of the connection manager.
Public propertySupportsDTCTransactionsReturns a Boolean that indicates if the connection supports Microsoft Distributed Transaction Coordinator (MS DTC) transactions.
Public propertyVariableDispenserGets the dispenser of the variables in the connection manager.
Public propertyVariablesGets the collection of variables in the connection manager.
Top
 Methods
  NameDescription
Public methodAcquireConnectionCreates an instance of the connection type.
Public methodDisposeReleases the resources used by the ConnectionManager.
Public methodEqualsDetermines whether two object instances are equal. (Inherited from DtsObject.)
Protected methodFinalize (Inherited from Object.)
Public methodGetExecutionPathReturns the execution path of the connection manager.
Public methodGetExpressionReturns a String that contains the expression for the specified property. Null means that no expression has been assigned.
Public methodGetHashCodeReturns the hash code for this instance. (Inherited from DtsObject.)
Public methodGetPackagePathGets or sets the path of the package that the connection applies to.
Public methodGetType (Inherited from Object.)
Public methodLoadFromXML(String, IDTSEvents)This method is not callable by your application code. To load a package that has been saved as .xml, use the Application..::.LoadPackage method.
Public methodLoadFromXML(XmlNode, IDTSEvents)This method is not callable by your application code. To load a package that has been saved as .xml, use the Application..::.LoadPackage method.
Protected methodMemberwiseClone (Inherited from Object.)
Public methodReleaseConnectionFrees the connection established during AcquireConnection. Called at design time and runtime.
Public methodSaveToXMLThis method is not callable by your application code. To save a package as .xml, use the Application..::.SaveToXml method.
Public methodSetExpressionAssigns the specified expression to the property. Specify nullNothingnullptra null reference (Nothing in Visual Basic) to remove an existing expression from the property.
Public methodSetQualifierChanges a qualifier on the connection manager after the connection manager has been created but before it is used in a running package.
Public methodToString (Inherited from Object.)
Top
 Events
  NameDescription
Public eventDisposedAdds an event handler to listen to the Disposed event on the ConnectionManager.
Top
 Remarks

A connection manager is a logical representation of a connection. At design time, in the graphical user interface, you use a connection manager to describe the physical connection that the runtime creates when the package runs. Integration Services provides different types of connection managers that enable packages to connect to a variety of data sources. For example, there is an ActiveX Data Objects (ADO) connection manager, an ADO.NET connection manager, an ODBC connection manager, and so on. For more information, see Extending Packages with Custom Objects.
 Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
 See Also

Reference

Microsoft.SqlServer.Dts.Runtime Namespace
© 2012 Microsoft. All rights reserved. Terms of Use | Trademarks | Privacy Statement
Page view tracker