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.


  • Order
    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.
  • Condition
    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](ms137547\(v=sql.90\).md), [Integration Services Expression Reference](ms141232\(v=sql.90\).md), [Operators (SSIS)](ms137538\(v=sql.90\).md), and [Functions (SSIS)](ms141671\(v=sql.90\).md)
  • Default output name
    Type a name for the default output, or use the default.

See Also

Other Resources

Integration Services Error and Message Reference
How to: Split a Dataset Using the Conditional Split Transformation

Help and Information

Getting SQL Server 2005 Assistance