Compartilhar via

  • Artigo

Interface IDtsConnectionService

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

Namespace:  Microsoft.SqlServer.Dts.Runtime.Design
Assembly:  Microsoft.SqlServer.Dts.Design (em Microsoft.SqlServer.Dts.Design.dll)

Sintaxe

'Declaração
Public Interface IDtsConnectionService
'Uso
Dim instance As IDtsConnectionService

public interface IDtsConnectionService

public interface class IDtsConnectionService

type IDtsConnectionService =  interface end

public interface IDtsConnectionService

O tipo IDtsConnectionService expõe os membros a seguir.

Propriedades

  Nome Descrição
Propriedade pública IsDesignerOnline Gets or sets a Boolean indicating whether the designer is working in an offline mode or online mode.

Início

Métodos

  Nome Descrição
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 connection type specified as a parameter.
Método público CreateConnection(String, ConnectionManagerUIArgs) Creates a new connection using the connection type specified as a parameter.
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.
Método público GetConnectionsOfType Returns all connections of the specified type found in the current package.
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.

Início

Comentários

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

Exemplos

The following code example shows the use of the IDtsConnectionService.

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