Skip to main content

Lookup Cache Path

The default path for Cache files used in lookups.

When generated SSIS packages use cache lookups, BimlFlex creates a cache connection per cached object whose connection string resolves at run time to a .caw cache file in this folder, through the LookupCachePath variable or $Project::LookupCachePath parameter. The design-time file path for the same connections defaults under the Root Path; the run-time location always comes from this setting.

When to Change This Setting

Point it at a local folder with enough space for the cache files on the machine executing the packages.

SettingInteraction
Root PathDesign-time base folder for the cache file connections

Notes

  • This setting is part of the Core settings category.
  • The default value for this setting is C:\BimlFlex\Cache.