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

The IDtsConnectionService type exposes the following members.

  NameDescription
Public propertyIsDesignerOnlineGets or sets a Boolean indicating whether the designer is working in an offline mode or online mode.
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 connection type specified as a parameter.
Public methodCreateConnection(String, ConnectionManagerUIArgs)Creates a new connection using the connection type specified as a parameter.
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.
Public methodGetConnectionsOfTypeReturns all connections of the specified type found in the current package.
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