This topic has not yet been rated - Rate this topic

ConnectionManager.SetQualifier Method

Changes a qualifier on the connection manager after the connection manager has been created but before it is used in a running package.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Syntax

C++

JScript

Copy

public void SetQualifier(
	string qualifier
)

Parameters

qualifier: Type: System.String
The new qualifier to set on the connection manager.

Remarks

The SetQualifier method modifies the value of the CreationName property by appending the fully-qualified provider name to the type of the connection manager. For example, the SetQualifier method has modified the name of the following ADO.NET connection manager by appending the fully-qualified provider name to "ADO.NET":

ADO.NET:System.Data.OleDb.OleDbConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

This method can be used to change the qualifier only during design time. SetQualifier cannot be called on the connection manager during package execution.

Reference

ConnectionManager Class

Microsoft.SqlServer.Dts.Runtime Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)