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.