Jaa


IDtsConnectionService Members

Provides a service that can be used by various user interfaces to create new connections.

The following tables list the members exposed by the IDtsConnectionService type.

Public Properties

  Name Description
ms211910.pubproperty(en-US,SQL.90).gif IsDesignerOnline Gets or sets a Boolean indicating whether the designer is working in an offline mode or online mode.

Top

Public Methods

  Name Description
ms211910.pubmethod(en-US,SQL.90).gif AddConnectionToPackage Adds existing connections to a package designer so that the designer is aware of a new connection manager
ms211910.pubmethod(en-US,SQL.90).gif CreateConnection Overloaded. Creates a new connection.
ms211910.pubmethod(en-US,SQL.90).gif CreateConnectionFromDataSource Displays a list of existing data sources and allows users to create connection managers based on data sources.
ms211910.pubmethod(en-US,SQL.90).gif EditConnection Overloaded. Edits an existing connection.
ms211910.pubmethod(en-US,SQL.90).gif GetAMOObject Retrieves the AMO object for an OLAP connection.
ms211910.pubmethod(en-US,SQL.90).gif GetConnections Retrieves all connection managers in the current package.
ms211910.pubmethod(en-US,SQL.90).gif GetConnectionsOfType Returns all connections of the specified type found in the current package.
ms211910.pubmethod(en-US,SQL.90).gif GetDataSource Retrieves the DataSource object for a connection.
ms211910.pubmethod(en-US,SQL.90).gif 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.
ms211910.pubmethod(en-US,SQL.90).gif SetReferencedProject Sets the referenced project to a connection manager.

Top

See Also

Reference

IDtsConnectionService Interface
Microsoft.SqlServer.Dts.Runtime.Design Namespace