DTS Programming

MaxCacheRows Property

The MaxCacheRows property specifies the maximum number of rows to cache.

Applies To

Syntax

object.MaxCacheRows [= value]

Part	Description
object	Expression that evaluates to a Lookup object
value	Maximum number of rows that are cached

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetMaxCacheRows(LONG *pRetVal);

HRESULT SetMaxCacheRows(LONG NewValue);

Remarks

The Execute method of the DTSLookups scripting object checks the cache of the Lookup object for the requested row before querying the lookup's data source. This results in significant performance improvement if the target row is usually found in the cache.

A value of 0 means no rows are cached. The default is 100.