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 _
)

void SetDataSourceID (
    ConnectionManager connectionManager,
    string dataSourceId
)

void SetDataSourceID (
    ConnectionManager^ connectionManager, 
    String^ dataSourceId
)

void SetDataSourceID (
    ConnectionManager connectionManager, 
    String dataSourceId
)

function SetDataSourceID (
    connectionManager : ConnectionManager, 
    dataSourceId : String
)

Parameter

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

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

Hinweise

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 Erstellen von Verbindungs-Managern.

Threadsicherheit

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.

Plattformen

Entwicklungsplattformen

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Zielplattforme

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Siehe auch

Verweis

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