UseCache Property
The UseCache property returns or sets whether cached information is used when enumerating the associated collection.
Applies To
| OLEDBProviderInfos Collection | TaskInfos Collection |
| ScriptingLanguageInfos Collection | TransformationInfos Collection |
Syntax
object.UseCache [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list. |
| value | Determines whether cached information is used to enumerate the associated collection. |
Data Type
Boolean
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetUseCache(VARIANT_BOOL *pRetVal);
HRESULT SetUseCache(VARIANT_BOOL NewValue);
Remarks
When UseCache is FALSE, the information about the components of the associated collection is obtained from the operating system registry. This requires all registered classes to be examined and may take a significant amount of time, depending on the amount of software installed on the computer.
Data Transformation Services (DTS) maintains a cache in the system registry of the components of each collection in the Applies To list and examines the appropriate cache, rather than all registered classes, when UseCache is TRUE. Use the Refresh method to refresh the appropriate cache from the system registry.