Any suggestions? Export (0) Print
Expand All

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.

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

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

public ref class ConnectionManager sealed : DtsObject, IDTSObjectHost, 
	IDTSPersist, IDTSName, IComponent, IDisposable, IDTSPropertiesProvider, 
	IDTSPropertiesProviderEx, IDTSPackagePath, IDTSExecutionPath

NameDescription
System_CAPS_pubpropertyConnectionString

Gets or sets the connection string used to establish a connection to a data source.

System_CAPS_pubpropertyCreationName

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

System_CAPS_pubpropertyDelayValidation

Gets or sets a Boolean that indicates whether package validation is delayed until the package runs.

System_CAPS_pubpropertyDescription

Gets or sets the description of the ConnectionManager object.

System_CAPS_pubpropertyHasExpressions

Gets a value that indicates whether the connection manager has properties set through expressions.

System_CAPS_pubpropertyHostType

Gets an enumeration that describes the type of host that the connection is being used by. This property is read-only.

System_CAPS_pubpropertyID

Gets the ID of the ConnectionManager. This property is read-only.

System_CAPS_pubpropertyInnerObject

Returns the specific connection type that was created. This property is read-only.

System_CAPS_pubpropertyName

Gets or sets the name of the ConnectionManager object.

System_CAPS_pubpropertyOfflineMode

Gets or sets a value that indicates whether the connection manager is in offline mode.

System_CAPS_pubpropertyProperties

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.

System_CAPS_pubpropertyProtectionLevel

Gets or sets the level of encryption performed on sensitive data that is contained in the package.

System_CAPS_pubpropertyQualifier

Gets or sets the qualifier for the connection manager.

System_CAPS_pubpropertyScope

Gets the scope of the connection manager.

System_CAPS_pubpropertySite

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the site of the connection manager.

System_CAPS_pubpropertySupportsDTCTransactions

Returns a Boolean that indicates if the connection supports Microsoft Distributed Transaction Coordinator (MS DTC) transactions.

System_CAPS_pubpropertyVariableDispenser

Gets the dispenser of the variables in the connection manager.

System_CAPS_pubpropertyVariables

Gets the collection of variables in the connection manager.

NameDescription
System_CAPS_pubmethodAcquireConnection(Object^)

Creates an instance of the connection type.

System_CAPS_pubmethodDispose()

Releases the resources used by the ConnectionManager.

System_CAPS_pubmethodEquals(Object^)

Determines whether two object instances are equal.(Inherited from DtsObject.)

System_CAPS_pubmethodGetExecutionPath()

Returns the execution path of the connection manager.

System_CAPS_pubmethodGetExpression(String^)

Returns a String that contains the expression for the specified property. Null means that no expression has been assigned.

System_CAPS_pubmethodGetHashCode()

Returns the hash code for this instance.(Inherited from DtsObject.)

System_CAPS_pubmethodGetPackagePath()

Gets or sets the path of the package that the connection applies to.

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodLoadFromXML(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.

System_CAPS_pubmethodLoadFromXML(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.

System_CAPS_pubmethodReleaseConnection(Object^)

Frees the connection established during AcquireConnection. Called at design time and runtime.

System_CAPS_pubmethodSaveToXML(XmlDocument^, XmlNode^, IDTSEvents^)

This method is not callable by your application code. To save a package as .xml, use the Application::SaveToXml method.

System_CAPS_pubmethodSetExpression(String^, String^)

Assigns the specified expression to the property. Specify null to remove an existing expression from the property.

System_CAPS_pubmethodSetQualifier(String^)

Changes a qualifier on the connection manager after the connection manager has been created but before it is used in a running package.

System_CAPS_pubmethodToString()

(Inherited from Object.)

NameDescription
System_CAPS_pubeventDisposed

Adds an event handler to listen to the Disposed event on the ConnectionManager.

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.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top
Show:
© 2016 Microsoft