Conditional Split in SSIS

This transformation lets you route your data flow to different outputs, based on criteria defined within the transformation’s editor.