DTS Programming
UpdateQuery Property
The UpdateQuery property specifies a string of one or more parameterized SQL statements to execute at the destination as the Update query.
Applies To
| DataDrivenQueryTask Object | TransformationSet Object |
| DataDrivenQueryTask2 Object |
Syntax
object.UpdateQuery [= 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 GetUpdateQuery(BSTR *pRetVal);
HRESULT SetUpdateQuery(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. The UpdateQuery property does not need to contain a Transact-SQL UPDATE statement.
The values of the columns specified by the UpdateQueryColumns property replace the parameters placeholders in the UpdateQuery in the order in which the columns were added to the collection.