--- title: "Conditional Split Transformation | Microsoft Docs" ms.custom: "" ms.date: "03/01/2017" ms.prod: sql ms.prod_service: "integration-services" ms.reviewer: "" ms.technology: integration-services ms.topic: conceptual f1_keywords: - "sql13.dts.designer.conditionalsplittrans.f1" - "sql13.dts.designer.conditionalsplittransformation.f1" helpviewer_keywords: - "Conditional Split transformation" - "route rows to different outputs [Integration Services]" ms.assetid: 3f8b5825-226f-413c-ba8f-0bb931ca3770 author: chugugrace ms.author: chugu --- # Conditional Split Transformation [!INCLUDE[ssis-appliesto](../../../includes/ssis-appliesto-ssvrpluslinux-asdb-asdw-xxx.md)] The Conditional Split transformation can route data rows to different outputs depending on the content of the data. The implementation of the Conditional Split transformation is similar to a CASE decision structure in a programming language. The transformation evaluates expressions, and based on the results, directs the data row to the specified output. This transformation also provides a default output, so that if a row matches no expression it is directed to the default output. ## Configuration of the Conditional Split Transformation You can configure the Conditional Split transformation in the following ways: - Provide an expression that evaluates to a Boolean for each condition you want the transformation to test. - Specify the order in which the conditions are evaluated. Order is significant, because a row is sent to the output corresponding to the first condition that evaluates to true. - Specify the default output for the transformation. The transformation requires that a default output be specified. Each input row can be sent to only one output, that being the output for the first condition that evaluates to true. For example, the following conditions direct any rows in the **FirstName** column that begin with the letter *A* to one output, rows that begin with the letter *B* to a different output, and all other rows to the default output. Output 1 `SUBSTRING(FirstName,1,1) == "A"` Output 2 `SUBSTRING(FirstName,1,1) == "B"` [!INCLUDE[ssISnoversion](../../../includes/ssisnoversion-md.md)] includes functions and operators that you can use to create the expressions that evaluate input data and direct output data. For more information, see [Integration Services (SSIS) Expressions](../../../integration-services/expressions/integration-services-ssis-expressions.md). The Conditional Split transformation includes the **FriendlyExpression** custom property. This property can be updated by a property expression when the package is loaded. For more information, see [Use Property Expressions in Packages](../../../integration-services/expressions/use-property-expressions-in-packages.md) and [Transformation Custom Properties](../../../integration-services/data-flow/transformations/transformation-custom-properties.md). This transformation has one input, one or more outputs, and one error output. You can set properties through [!INCLUDE[ssIS](../../../includes/ssis-md.md)] Designer or programmatically. The **Advanced Editor** dialog box reflects the properties that can be set programmatically. For more information about the properties that you can set in the **Advanced Editor** dialog box or programmatically, click one of the following topics: - [Common Properties](https://msdn.microsoft.com/library/51973502-5cc6-4125-9fce-e60fa1b7b796) - [Transformation Custom Properties](../../../integration-services/data-flow/transformations/transformation-custom-properties.md) For more information about how to set properties, click one of the following topics: - [Split a Dataset by Using the Conditional Split Transformation](../../../integration-services/data-flow/transformations/split-a-dataset-by-using-the-conditional-split-transformation.md) - [Set the Properties of a Data Flow Component](../../../integration-services/data-flow/set-the-properties-of-a-data-flow-component.md) ## Related Tasks [Split a Dataset by Using the Conditional Split Transformation](../../../integration-services/data-flow/transformations/split-a-dataset-by-using-the-conditional-split-transformation.md) ## 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. ### 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](../../../integration-services/expressions/integration-services-ssis-expressions.md), [Operators (SSIS Expression)](../../../integration-services/expressions/operators-ssis-expression.md), and [Functions (SSIS Expression)](../../../integration-services/expressions/functions-ssis-expression.md) **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](https://msdn.microsoft.com/library/5f8da390-fab5-44f8-b268-d8fa313ce4b9) dialog box. ## See Also [Data Flow](../../../integration-services/data-flow/data-flow.md) [Integration Services Transformations](../../../integration-services/data-flow/transformations/integration-services-transformations.md)