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.