IDtsConnectionService.SetDataSourceID Method

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 _
)
'Usage
Dim instance As IDtsConnectionService
Dim connectionManager As ConnectionManager
Dim dataSourceId As String

instance.SetDataSourceID(connectionManager, _
    dataSourceId)

void SetDataSourceID(
    ConnectionManager connectionManager,
    string dataSourceId
)

void SetDataSourceID(
    ConnectionManager^ connectionManager, 
    String^ dataSourceId
)

abstract SetDataSourceID : 
        connectionManager:ConnectionManager * 
        dataSourceId:string -> unit 

function SetDataSourceID(
    connectionManager : ConnectionManager, 
    dataSourceId : String
)

Parameters

• connectionManager
  Type: Microsoft.SqlServer.Dts.Runtime.ConnectionManager
  The connection manager that contains the reference to the dataSourceID.

• dataSourceId
  Type: System.String
  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.

See Also

Reference

IDtsConnectionService Interface

IDtsConnectionService Members

Microsoft.SqlServer.Dts.Runtime.Design Namespace