IDtsConnectionService Interface

 

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 (in Microsoft.SqlServer.Dts.Design.dll)

public interface class IDtsConnectionService : IDtsConnectionBaseService

NameDescription
System_CAPS_pubpropertyIsDesignerOnline

Gets a value that indicates whether the designer is working in an online mode.(Inherited from IDtsConnectionBaseService.)

NameDescription
System_CAPS_pubmethodAddConnectionToPackage(ConnectionManager^)

Adds existing connections to a package designer so that the designer is aware of a new connection manager

System_CAPS_pubmethodCreateConnection(String^)

Creates a new connection using the specified connection type.(Inherited from IDtsConnectionBaseService.)

System_CAPS_pubmethodCreateConnection(String^, ConnectionManagerUIArgs^)

Creates a new connection using the specified connection type and argument.(Inherited from IDtsConnectionBaseService.)

System_CAPS_pubmethodCreateConnectionFromDataSource()

Displays a list of existing data sources and allows users to create connection managers based on data sources.

System_CAPS_pubmethodEditConnection(ConnectionManager^)

Edits a specific existing connection and returns a value that indicates whether the connection was modified.

System_CAPS_pubmethodEditConnection(ConnectionManager^, ConnectionManagerUIArgs^)

Edits a specific existing connection and returns a value to indicate whether the connection was modified.

System_CAPS_pubmethodGetAMOObject(ConnectionManager^)

Retrieves the AMO object for an OLAP connection.

System_CAPS_pubmethodGetConnections()

Retrieves all connection managers in the current package.(Inherited from IDtsConnectionBaseService.)

System_CAPS_pubmethodGetConnectionsOfType(String^)

Returns all connections of the specified type found in the current package.(Inherited from IDtsConnectionBaseService.)

System_CAPS_pubmethodGetDataSource(ConnectionManager^)

Retrieves the DataSource object for a connection.

System_CAPS_pubmethodSetDataSourceID(ConnectionManager^, String^)

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.

System_CAPS_pubmethodSetReferencedProject(ConnectionManager^, String^)

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;
Return to top
Show: