How to use Conditional Split in SSIS

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

cs1.png

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

cs2.png

Here, Just I' splitting the male records and female records separately. If the record is not matching in any one of this, then it will go to Conditional Split Default Output.

Step 3: Male and Female records are splitted separately.

cs3.png


 cs4.png

cs5.png