Home > SSIS > Get your data from cache – Cache Transform task – SSIS

Get your data from cache – Cache Transform task – SSIS

Cache is a component that stores data and helps the system to serve the stored data from the cache instead disk. It is more powerful component in the system with high performance read and write operation. Cache improves performance of an application drastically.

Cache Transform task

Cache Transform Transformation task writes data to a cache connection manager. It carries unique row from the data source with a index column to the cache.

we can save the data into cache or cache file (*.caw) using cache connection manager.By default, it goes to cache.

This task is available from SQL Server 2008 version on-wards.

How to use this task?

We need to have a data source, Cache Transform task and Cache connection manager.

1. Data source is used to connect to the available data in the disk.

2. Cache Transform task is used to write the data from the data source to Cache connection manager (Cache or Cache file).

3. Cache connection manger helps to reuse the cache data in the lookup task.


Step 1: Create a package and Add a data flow task in to the control flow.

Step 2: Go to data flow design interface add Ado.Net data source.

Step 3: Connect the data source to adventure works database table customer. I have selected column from the table for cache.

Step 4: Add Cache Transform task and connect data source task with it.

Step 5: Open Cache Transformation Editor. Create new cache connection.

Step 6: Go to column tab and select the column index position. At least one column should have index position. Click OK.

Step 7: Now, go to mappings tab in the cache transformation editor and map each input source data to the corresponding destination cache column. Source and Destination column data type should be same otherwise an error message will be shown by SSIS designer.

Step 8: Click OK and execute the package

Where to use Cache connection manager?

Lookup task.

MSDN article.

Thanks for reading.

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: