Поделиться через

Интерфейс IDtsConnectionService

  • Статья

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

Пространство имен:  Microsoft.SqlServer.Dts.Runtime.Design
Сборка:  Microsoft.SqlServer.Dts.Design (в Microsoft.SqlServer.Dts.Design.dll)

Синтаксис

'Декларация
Public Interface IDtsConnectionService _
    Inherits IDtsConnectionBaseService
'Применение
Dim instance As IDtsConnectionService

public interface IDtsConnectionService : IDtsConnectionBaseService

public interface class IDtsConnectionService : IDtsConnectionBaseService

type IDtsConnectionService =  
    interface 
        interface IDtsConnectionBaseService 
    end

public interface IDtsConnectionService extends IDtsConnectionBaseService

Тип IDtsConnectionService обеспечивает доступ к следующим элементам.

Свойства

  Имя Описание
Открытое свойство IsDesignerOnline Gets a value that indicates whether the designer is working in an online mode. (Производный от IDtsConnectionBaseService.)

В начало

Методы

  Имя Описание
Открытый метод AddConnectionToPackage Adds existing connections to a package designer so that the designer is aware of a new connection manager
Открытый метод CreateConnection(String) Creates a new connection using the specified connection type. (Производный от IDtsConnectionBaseService.)
Открытый метод CreateConnection(String, ConnectionManagerUIArgs) Creates a new connection using the specified connection type and argument. (Производный от IDtsConnectionBaseService.)
Открытый метод CreateConnectionFromDataSource Displays a list of existing data sources and allows users to create connection managers based on data sources.
Открытый метод EditConnection(ConnectionManager) Edits a specific existing connection and returns a value that indicates whether the connection was modified.
Открытый метод EditConnection(ConnectionManager, ConnectionManagerUIArgs) Edits a specific existing connection and returns a value to indicate whether the connection was modified.
Открытый метод GetAMOObject Retrieves the AMO object for an OLAP connection.
Открытый метод GetConnections Retrieves all connection managers in the current package. (Производный от IDtsConnectionBaseService.)
Открытый метод GetConnectionsOfType Returns all connections of the specified type found in the current package. (Производный от IDtsConnectionBaseService.)
Открытый метод GetDataSource Retrieves the DataSource object for a connection.
Открытый метод 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.
Открытый метод SetReferencedProject Sets the referenced project to a connection manager.

В начало

Замечания

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

Примеры

The following code example shows the use of the IDtsConnectionService.

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

См. также

Справочник

Пространство имен Microsoft.SqlServer.Dts.Runtime.Design