IDtsConnectionService.SetDataSourceID Method

Article
12/03/2008

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.

Namespace: Microsoft.SqlServer.Dts.Runtime.Design
Assembly: Microsoft.SqlServer.Dts.Design (in microsoft.sqlserver.dts.design.dll)

Syntax

'Declaration
Sub SetDataSourceID ( _
    connectionManager As ConnectionManager, _
    dataSourceId As String _
)

void SetDataSourceID (
    ConnectionManager connectionManager,
    string dataSourceId
)

void SetDataSourceID (
    ConnectionManager^ connectionManager, 
    String^ dataSourceId
)

void SetDataSourceID (
    ConnectionManager connectionManager, 
    String dataSourceId
)

function SetDataSourceID (
    connectionManager : ConnectionManager, 
    dataSourceId : String
)

Parameters

connectionManager
The connection manager that contains the reference to the dataSourceID.

dataSourceId
The GUID of the data source or data source view.

Remarks

This method is used to dereference into the DataSources collection of the AMO database object. Each SSIS project has a corresponding AMO database object, so that the data source and data source views have an established storage location. For more information, see Creating Connection Managers.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Share via