FetchBufferSize Property (DTS)

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

Applies To

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

Remarks

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

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetFetchBufferSize(LONG *pRetVal);

HRESULT SetFetchBufferSize(LONG NewValue);