Share via


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 네임스페이스