DTS Programming

UserQuery Property

The UserQuery property specifies a string of one or more parameterized SQL statements to execute at the destination as the user query.

Applies To

DataDrivenQueryTask Object	TransformationSet Object
DataDrivenQueryTask2 Object

Syntax

object.UserQuery [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	Parameterized string of SQL statements

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetUserQuery(BSTR *pRetVal);

HRESULT SetUserQuery(BSTR NewValue);

Remarks

Although the name of a data driven query property is preset, its content is not enforced. Any of the queries may be used for any desired operation. The nomenclature is provided as a convenient means of identification. Typically, the UserQuery property contains a stored procedure reference.

The values of the columns specified by the UserQueryColumns property replace the parameter placeholders in the UserQuery in the order in which the columns were added to the collection.