Conditional Split Transformation Editor
Applies To: SQL Server 2016
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.
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.
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.
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.