Cache Connection Manager
Applies To: SQL Server 2016
The Cache connection manager reads data from the Cache transform or from a cache file (.caw), and can save the data to a cache file. Whether you configure the Cache connection manager to use a cache file, the data is always stored in memory.
The Cache Transform transformation writes data from a connected data source in the data flow to a Cache connection manager. The Lookup transformation in a package performs lookups on the data.
You can configure the Cache connection manager in the following ways:
Indicate whether to use a cache file.
If you configure the cache connection manager to use a cache file, the connection manager will do one of the following actions:
Save data to the file when a Cache Transform transformation is configured to write data from a data source in the data flow to the Cache connection manager.
Read data from the cache file.
For more information, see Cache Transform.
Change metadata for the columns stored in the cache.
Update the cache file name at runtime by using an expression to set the ConnectionString property. For more information, see Use Property Expressions in Packages.
You can set properties through Integration Services Designer or programmatically.
For more information about the properties that you can set in Integration Services Designer, see Cache Connection Manager Editor.