Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

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 Expression), and String Functions and Other Functions (SSIS Expression)

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft