MSBI # 63 – SSIS # 26 – Data Flow Task # 12 – Conditional Split Transformation– Detailed information & Explanation with example , Use & Properties

Hi folks,

I know I am writing very less these day I hoping I will continue writing from February end..

Continuing from my last post on transformation task..

• MSBI # 57 – SSIS # 22 – Data Flow Task # 8 – Aggregate Transformation Task
• MSBI # 59 – SSIS # 23 – Data Flow Task # 9 – Audit Transformation Task
• MSBI # 60 – SSIS # 24 – Data Flow Task # 10 – Cache Transform Task
• MSBI # 61 – SSIS # 25 – Data Flow Task # 11 – Character Map Transformation

We are covering following points

Why Conditional Split Transformation Task is Use ?

How Conditional Split Transformation Task is look like ?

Features of Conditional Split Transformation Task

How to use Conditional Split Transformation Task ?

Demonstration of using Conditional Split Transformation Task ?

Various Properties For each Conditional Split Transformation Task ?

Reference link For Conditional Split Transformation Task

Why Conditional Split Transformation Task is Use ?

Conditional Split Transformation task use when want to direct subsets of data to different locations, such as sending centrally collected data to appropriate branches or within the dataflow when we want to apply different business rules to certain subsets of the data, before merging this Dataset.

This is most useful transformation in Data Flow Task where we can traverse through different condition.

In Conditional Split Transformation incoming data can be split into multiple outputs as per the conditions specified. It has a default output too that handles all the rows that do not match to any conditions

How Conditional Split Transformation Task is look like ?

Features of Conditional Split Transformation Task

When we need to perform one to many operation we often use conditional transformation

Lets consider we need to perform various operation in same database

How to use Conditional Split Transformation Task ? and Demonstration of using Conditional Split Transformation Task ?

This is as simple as derived column transformation which have already discuss ..

Just drag out this task from Data Flow Tasks

Once we are ready to use we can configure as shown in following diagram

Various Properties For each Conditional Split Transformation Task ?

Following are various properties for Split Transformation

Reference link For Conditional Split Transformation Task

http://www.dotnetfunda.com/articles/article1214-conditional-split-in-ssis.aspx

Hope this helps !!

Hope you have understood overall Conditional Split Transformation and its types and usage

If you really like reading my blog and understood at lest few thing then please don’t forget to subscribe my blog

If you wan daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog

Where todays links are

Dactylonomy of Web Resource