The SourceQueryConnectionID property sets or returns the connection ID of the connection against which a query will be run. The query provides the value to which a Data Transformation Services (DTS) package object property will be set by the DynamicPropertiesTask object, when the SourceType property is DTSDynamicPropertiesSourceType_Query.
object.SourceQueryConnectionID [= number]
| Part | Description |
|---|---|
| object | Expression that evaluates to a DynamicPropertiesTaskAssignment object |
| number | Connection ID against which a query will be run to provide the value to which a DTS package object property will be set |
Long
Read/write
HRESULT SourceQueryConnectionID(long* pRetVal);
HRESULT SourceQueryConnectionID(long pRetVal);
The SQL query to be run is specified by the SourceQuerySQL property.