SSIS:Conditional Split Transformation

Refer Source Video: SSIS Conditional Split Transformation Part 1 Video Example SSIS 2012

2005,2008,2008 R2, 2012 - same. No much difference.
DataFlow

OLEDB DataSource:

SQL Command: query ( UNION ALL  of  two resultset)

Derieved Column: To view the values , "Condition" , column define the condition for spliting. The "Order" of  the condition important, accordingly it will execute.

Why "Order" is important, see in the below video.

Refer Source Video:SSIS Conditional Split IS NOT NULL Part 3 Video Example SSIS 201

If you have NULL  value then the Conditional Split Transformation , will stop. If  one adds like ISNULL(columnname) as the codition , it still will not work and other condition it will not run until the "Order" the ISNULL having condition is first.

Refer Source Video:SSIS Conditional Split Default Output Name Part 2 Video Example SSIS

"Conditional Split Transformation" Editor, the rows that do not meet any condition defined in the condition criteria will be lost, to capture it , in "Default Output name:" give a name and in Data Flow add a Derived Column & add , so those rows are captured.

Refer Source Video:SSIS Conditional Split Configure Error Output Part 4 Video Example

If  you have NULL value or for any condition you want those row to fall into another category then in the "Conditional Split Transformation" , there is a "Red Arrow" in that you specify the "Redirect" output of conditions , thats the same you see in "Configure Error Output", so using a 'Derieved Column" , one can see the error rows.

------------------------------------------------------------------------------------------------------------
Refer Source Video:Conditional Split Transformation In SSIS

If  in "Condition Split Transformation" one want to split data and put into different sources like one to "Flat file" and other set to  any other database.

------------------------------------------------------------------------------------------------------------