Conditional Split Transformation Editor

Use the Conditional Split Transformation Editor dialog box to create expressions, set the order in which expressions are evaluated, and name the outputs of a conditional split. This dialog box includes mathematical, string, and date/time functions and operators that you can use to build expressions. The first condition that evaluates as true determines the output to which a row is directed.


The Conditional Split transformation directs each input row to one output only. If you enter multiple conditions, the transformation sends each row to the first output for which the condition is true and disregards subsequent conditions for that row. If you need to evaluate several conditions successively, you may need to concatenate multiple Conditional Split transformations in the data flow.

To learn more about the Conditional Split transformation, see Conditional Split Transformation.


Select a row and use the arrow keys at right to change the order in which to evaluate expressions.

Output Name

Provide an output name. The default is a numbered list of cases; however, you can choose any unique, descriptive name.


Type an expression or build one by dragging from the list of available columns, variables, functions, and operators.

The value of this property can be specified by using a property expression.

Related topics: Using Expressions in Packages, Integration Services Expression Reference, Operators (SSIS Expressions), and Functions (SSIS Expressions)

Default output name

Type a name for the default output, or use the default.

Configure error output

Specify how to handle errors by using the Configure Error Output dialog box.

Community Additions