DTS Programming

FetchBufferSize Property

The FetchBufferSize property specifies the number of rows to fetch in a single operation from the OLE DB source.

Applies To

DataDrivenQueryTask Object	DataPumpTask2 Object
DataDrivenQueryTask2 Object	TransformationSet Object
DataPumpTask Object

Syntax

object.FetchBufferSize [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	Number of rows to fetch in a single operation

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetFetchBufferSize(LONG *pRetVal);

HRESULT SetFetchBufferSize(LONG NewValue);

Remarks

Each row may be buffered by the OLE DB provider. When calling IRowset::GetNextRows, adjust the FetchBufferSize property to achieve the best balance between memory usage and reduced overhead. A value greater than 1 is ignored if the data source uses binary large object (BLOB) storage. The default is 100.