ConditionalSplit in SSIS



Step 1 : Place the ConditionalSplit component from the Toolbox and connect the source.

SSIS1.gif

Step 2 : Go to Edit option and add the condition like below.

SSIS2.gif

Here, the male records and female records are being split separately. If the record is not matching in any one of these, then it will go to the Conditional Split Default Output.

Step 3: Male and Female records are split separately.

SSIS3.gif

SSIS4.gif

SSIS5.gif