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.