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.
Note
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.
Options
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: Integration Services (SSIS) Expressions, Operators (SSIS Expression), and 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.
See Also
Integration Services Error and Message Reference
Split a Dataset by Using the Conditional Split Transformation