MSBI # 60 – SSIS # 24 – Data Flow Task # 10 – Cache Transform Task- Detailed information & Explanation with example , Use & Properties

Hi Geeks,

Continuing from my last post on SSIS – Data Flow Task

In this article we are going to cover Cache Transform Task with points

  • Why Cache Transformation Task is Use ?
  • How Cache Transformation Task is look like ?
  • Features of Cache Transformation Task
  • How to use Cache Transformation Task ?
  • What is alternative For Each Cache Transformation Task ?
  • Demonstration of using Cache Transformation Task ?
  • Various Properties For each Cache Transformation Task ?
  • Reference link For Cache Transformation Task

Why Cache Transformation Task is Use ?

We can say Cache Transform is buffer storing component in SSIS

We can use Cache Connection Manager with any SQL command such as joins and then Connection manager as your Source for any other transformation

The Cache connection manager does not support the Binary Large Object (BLOB) data types DT_TEXT, DT_NTEXT, and DT_IMAGE. If the reference dataset contains a BLOB data type, the component will fail when you run the package

The transformation that writes data from a connected data source in the data flow to a Cache connection manager that saves the data to a cache file. The Lookup transformation performs lookups on the data in the cache file

How Cache Transformation Task is look like ?

image_thumb2

Features of Cache Transformation Task

The Cache connection manager does not support the Binary Large Object (BLOB) data types DT_TEXT, DT_NTEXT, and DT_IMAGE. If the reference dataset contains a BLOB data type, the component will fail when you run the package

The Cache Transform writes only unique rows to the Cache connection manager.

How to use Cache Transformation Task ?

What is alternative For Each Cache Transformation Task ?

Connection Manager

Demonstration of using Cache Transformation Task ?

Drag task from Data flow tab

image

We need to create Create Connection Manager

image

image

Configuration in General Tab

image

In this we need to see and decide Which should be our Cached Column

image

In this tab we must need to specify at least on Index Position to 1

image

If we are not specifying index position it will throw following error

image  

Now just update primary key to value 1 

image

It will also create one cache connection manager

image

After setting up everything we can ready to run package

image

Various Properties For each Cache Transformation Task ?

image

Reference link For Cache Transformation Task

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: