DTS Programming
MaxCacheRows Property
The MaxCacheRows property specifies the maximum number of rows to cache.
Applies To
| Lookup Object |
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.