Applies To: SQL Server 2016
The Cache Transform transformation generates a reference dataset for the Lookup Transformation by writing data from a connected data source in the data flow to a Cache connection manager. The Lookup transformation performs lookups by joining data in input columns from a connected data source with columns in the reference database.
You can use the Cache connection manager when you want to configure the Lookup Transformation to run in the full cache mode. In this mode, the reference dataset is loaded into cache before the Lookup Transformation runs.
For instructions on how to configure the Lookup transformation in full cache mode with the Cache connection manager and Cache Transform transformation, see Implement a Lookup Transformation in Full Cache Mode Using the Cache Connection Manager.
For more information on caching the reference dataset, see Lookup Transformation.
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 connection manager to save the data to a cache file (.caw).
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 Set the Properties of a Data Flow Component.