Compartir a través de

Interfaz IDtsConnectionService

  • Artículo

Provides a service that can be used by various user interfaces to create new connections.

Espacio de nombres:  Microsoft.SqlServer.Dts.Runtime.Design
Ensamblado:  Microsoft.SqlServer.Dts.Design (en Microsoft.SqlServer.Dts.Design.dll)

Sintaxis

'Declaración
Public Interface IDtsConnectionService _
    Inherits IDtsConnectionBaseService
'Uso
Dim instance As IDtsConnectionService

public interface IDtsConnectionService : IDtsConnectionBaseService

public interface class IDtsConnectionService : IDtsConnectionBaseService

type IDtsConnectionService =  
    interface 
        interface IDtsConnectionBaseService 
    end

public interface IDtsConnectionService extends IDtsConnectionBaseService

El tipo IDtsConnectionService expone los siguientes miembros.

Propiedades

  Nombre Descripción
Propiedad pública IsDesignerOnline Gets a value that indicates whether the designer is working in an online mode. (Se hereda de IDtsConnectionBaseService.)

Arriba

Métodos

  Nombre Descripción
Método público AddConnectionToPackage Adds existing connections to a package designer so that the designer is aware of a new connection manager
Método público CreateConnection(String) Creates a new connection using the specified connection type. (Se hereda de IDtsConnectionBaseService.)
Método público CreateConnection(String, ConnectionManagerUIArgs) Creates a new connection using the specified connection type and argument. (Se hereda de IDtsConnectionBaseService.)
Método público CreateConnectionFromDataSource Displays a list of existing data sources and allows users to create connection managers based on data sources.
Método público EditConnection(ConnectionManager) Edits a specific existing connection and returns a value that indicates whether the connection was modified.
Método público EditConnection(ConnectionManager, ConnectionManagerUIArgs) Edits a specific existing connection and returns a value to indicate whether the connection was modified.
Método público GetAMOObject Retrieves the AMO object for an OLAP connection.
Método público GetConnections Retrieves all connection managers in the current package. (Se hereda de IDtsConnectionBaseService.)
Método público GetConnectionsOfType Returns all connections of the specified type found in the current package. (Se hereda de IDtsConnectionBaseService.)
Método público GetDataSource Retrieves the DataSource object for a connection.
Método público SetDataSourceID Allows the connection string for a run-time connection manager to be in synchronization with the connection string of a Data Source object, if both are in the same project. This synchronization is done whenever a package is opened in the designer.
Método público SetReferencedProject Sets the referenced project to a connection manager.

Arriba

Comentarios

This service can be used by any kind of user interface, whether that be a task, connection manager, transform, log provider, or others.

Ejemplos

The following code example shows the use of the IDtsConnectionService.

IDtsConnectionService dtsConnectionService = serviceProvider.GetService(typeof(IDtsConnectionService)) as IDtsConnectionService;

Vea también

Referencia

Espacio de nombres Microsoft.SqlServer.Dts.Runtime.Design