Export (0) Print
Expand All

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 IDtsConnectionService : IDtsConnectionBaseService

The IDtsConnectionService type exposes the following members.

  NameDescription
Public propertyIsDesignerOnlineGets a value that indicates whether the designer is working in an online mode. (Inherited from IDtsConnectionBaseService.)
Top

  NameDescription
Public methodAddConnectionToPackageAdds existing connections to a package designer so that the designer is aware of a new connection manager
Public methodCreateConnection(String)Creates a new connection using the specified connection type. (Inherited from IDtsConnectionBaseService.)
Public methodCreateConnection(String, ConnectionManagerUIArgs)Creates a new connection using the specified connection type and argument. (Inherited from IDtsConnectionBaseService.)
Public methodCreateConnectionFromDataSourceDisplays a list of existing data sources and allows users to create connection managers based on data sources.
Public methodEditConnection(ConnectionManager)Edits a specific existing connection and returns a value that indicates whether the connection was modified.
Public methodEditConnection(ConnectionManager, ConnectionManagerUIArgs)Edits a specific existing connection and returns a value to indicate whether the connection was modified.
Public methodGetAMOObjectRetrieves the AMO object for an OLAP connection.
Public methodGetConnectionsRetrieves all connection managers in the current package. (Inherited from IDtsConnectionBaseService.)
Public methodGetConnectionsOfTypeReturns all connections of the specified type found in the current package. (Inherited from IDtsConnectionBaseService.)
Public methodGetDataSourceRetrieves the DataSource object for a connection.
Public methodSetDataSourceIDAllows 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.
Public methodSetReferencedProjectSets the referenced project to a connection manager.
Top

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;

Community Additions

ADD
Show:
© 2014 Microsoft