ConditionalSplit in SSIS

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



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


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.