Cache Transform

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.

For more information, see Cache Connection Manager and Cache Connection Manager Editor.

Configuring the Cache Transform

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.

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.