IDtsConnectionService Interface
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Provides a service that can be used by various user interfaces to create new connections.
public interface class IDtsConnectionService : Microsoft::SqlServer::Dts::Runtime::Design::IDtsConnectionBaseServicepublic interface IDtsConnectionService : Microsoft.SqlServer.Dts.Runtime.Design.IDtsConnectionBaseServicetype IDtsConnectionService = interface
interface IDtsConnectionBaseServicePublic Interface IDtsConnectionService
Implements IDtsConnectionBaseService- Implements
Examples
The following code example shows the use of the IDtsConnectionService.
IDtsConnectionService dtsConnectionService = serviceProvider.GetService(typeof(IDtsConnectionService)) as IDtsConnectionService;
Remarks
This service can be used by any kind of user interface, whether that be a task, connection manager, transform, log provider, or others.
Properties
| IsDesignerOnline |
Gets a value that indicates whether the designer is working in an online mode. (Inherited from IDtsConnectionBaseService) |
Methods
| AddConnectionToPackage(ConnectionManager) |
Adds existing connections to a package designer so that the designer is aware of a new connection manager |
| CreateConnection(String, ConnectionManagerUIArgs) |
Creates a new connection using the specified connection type and argument. (Inherited from IDtsConnectionBaseService) |
| CreateConnection(String) |
Creates a new connection using the specified connection type. (Inherited from IDtsConnectionBaseService) |
| CreateConnectionFromDataSource() |
Displays a list of existing data sources and allows users to create connection managers based on data sources. |
| EditConnection(ConnectionManager, ConnectionManagerUIArgs) |
Edits a specific existing connection and returns a value to indicate whether the connection was modified. |
| EditConnection(ConnectionManager) |
Edits a specific existing connection and returns a value that indicates whether the connection was modified. |
| GetAMOObject(ConnectionManager) |
Retrieves the AMO object for an OLAP connection. |
| GetConnections() |
Retrieves all connection managers in the current package. (Inherited from IDtsConnectionBaseService) |
| GetConnectionsOfType(String) |
Returns all connections of the specified type found in the current package. (Inherited from IDtsConnectionBaseService) |
| GetDataSource(ConnectionManager) |
Retrieves the DataSource object for a connection. |
| SetDataSourceID(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. |
| SetReferencedProject(ConnectionManager, String) |
Sets the referenced project to a connection manager. |