UserQueryColumns Property

DTS Programming

DTS Programming

UserQueryColumns Property

The UserQueryColumns property returns a reference to a collection of Column objects that serve as parameters for the query specified by the UserQuery property.

Applies To
DataDrivenQueryTask Object TransformationSet Object
DataDrivenQueryTask2 Object  
Syntax

object.UserQueryColumns

Part Description
object Expression that evaluates to an object in the Applies To list

Data Type

Columns Collection

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetUserQueryColumns(IDTSColumns **pRetVal);

Remarks

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.

See Also

Adding DTS Query Strings

Column Object

DeleteQueryColumns Property

InsertQueryColumns Property

UpdateQueryColumns Property

UserQuery Property