DTS Programming

SourceQuerySQL Property

The SourceQuerySQL property sets or returns a string that is an SQL query. The query provides the value to which a Data Transformation Services (DTS) package object property is set by the DynamicPropertiesTask object, when the SourceType property is DTSDynamicPropertiesSourceType_Query.

Applies To

DynamicPropertiesTaskAssignment Object

Syntax

object.SourceQuerySQL [= query]

Part	Description
object	Expression that evaluates to a DynamicPropertiesTaskAssignment object
query	SQL query that provides the value to which a DTS package object property is set

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT SourceQuerySQL(BSTR* pRetVal);

HRESULT SourceQuerySQL(BSTR pRetVal);

Remarks

In general, it is recommended that you program the SQL query to return a single row containing a single field. Only the first field of the first row is used to set the specified package object property.

The query is run against the connection identified by the SourceQueryConnectionID property.