Conditional Split (SSIS)

The Conditional Split transformation can route data rows to different outputs depending on the content of the data.
It is similar to a CASE decision structure in a programming language.

You can configure the Conditional Split transformation in the following ways:

• Provide an expression that evaluates to a Boolean for each condition you want the transformation to test.
• Specify the order in which the conditions are evaluated. Order is significant, because a row is sent to the output corresponding to the first condition that evaluates to true.
• Specify the default output for the transformation. The transformation requires that a default output be specified.

Each input row can be sent to only one output, that being the output for the first condition that evaluates to true.

http://msdn.microsoft.com/en-us/library/ms137886.aspx