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;