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.