FetchBufferSize Property

DTS Programming

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.

See Also

InsertCommitSize Property