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.
The Cache Transform writes only unique rows to the Cache connection manager.
You can configure the Cache connection manager to save the data to a cache file (.caw).
In a single package, only one Cache Transform can write data to the same Cache connection manager. If the package contains multiple Cache Transforms, the first Cache Transform that is called when the package runs, writes the data to the connection manager. The write operations of subsequent Cache Transforms fail.
You can configure the Cache Transform in the following ways:
Specify the Cache connection manager.
Map the input columns in the Cache Transform to destination columns in the Cache connection manager.
Each input column must be mapped to a destination column, and the column data types must match. Otherwise, Integration Services Designer displays an error message.
You can use the Cache Connection Manager Editor to modify column data types, names, and other column properties.
You can set properties through Integration Services Designer. For more information about the properties that you can set in the Advanced Editor dialog box, see Transformation Custom Properties.
For more information about how to set properties, see How to: Set the Properties of a Data Flow Component.