ConnectionManager Class

Article
12/15/2008

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.

Espace de noms: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Syntaxe

'Déclaration
Public NotInheritable Class ConnectionManager
    Inherits DtsObject
    Implements IDTSObjectHost, IDTSPersist, IDTSName, IComponent, _
    IDisposable, IDTSPropertiesProvider, IDTSPackagePath

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

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

public final class ConnectionManager extends DtsObject implements IDTSObjectHost, IDTSPersist, 
    IDTSName, IComponent, IDisposable, IDTSPropertiesProvider, IDTSPackagePath

public final class ConnectionManager extends DtsObject implements IDTSObjectHost, IDTSPersist, 
    IDTSName, IComponent, IDisposable, IDTSPropertiesProvider, IDTSPackagePath

Notes

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 Gestionnaires de connexions.

Inheritance Hierarchy

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

Sécurité des threads

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

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

ConnectionManager Members
Microsoft.SqlServer.Dts.Runtime Namespace

Partager via