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.