IsPackageDSORowset Property

DTS Programming

DTS Programming

IsPackageDSORowset Property

The IsPackageDSORowset property specifies whether the current step executes and returns a rowset when the Data Transformation Services (DTS) package is a rowset provider.

Applies To
Step Object Step2 Object
Syntax

object.IsPackageDSORowset [= value]

Part Description
object Expression that evaluates to an object in the Applies To list.
value A value indicating whether the current step executes and returns a rowset

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetIsPackageDSORowset(VARIANT_BOOL *pRetVal);

HRESULT SetIsPackageDSORowset(VARIANT_BOOL NewValue);

Remarks

The default is FALSE.

The IsPackageDSORowset property cannot be set to TRUE for steps that reference the DTS flat file OLE DB provider, because that provider does not support the IDBSchemaRowset interface. Other providers that do not support IDBSchemaRowset also cannot be referenced by steps that return DSO rowsets.

See Also

Querying a Package with OPENROWSET

Issuing Distributed Queries Against Package Data