DTS Programming
SourceQueryConnectionID Property
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.
Applies To
| DynamicPropertiesTaskAssignment Object |
Syntax
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 |
Data Type
Long
Modifiable
Read/write
Prototype (C/C++)
HRESULT SourceQueryConnectionID(long* pRetVal);
HRESULT SourceQueryConnectionID(long pRetVal);
Remarks
The SQL query to be run is specified by the SourceQuerySQL property.