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..

    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 ?

image_thumb44_thumb_thumb

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

image

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

image

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

image

Various Properties For each Conditional Split Transformation Task ?

Following are various properties for Split Transformation

image

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

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: