How to: Split a Dataset Using the Conditional Split Transformation

To add and configure a Conditional Split transformation, the package must already include at least one Data Flow task and a source.

To conditionally split a dataset

  1. In Business Intelligence Development Studio, open the Integration Services project that contains the package you want.

  2. In Solution Explorer, double-click the package to open it.

  3. Click the Data Flow tab, and, from the Toolbox, drag the Conditional Split transformation to the design surface.

  4. Connect the Conditional Split transformation to the data flow by dragging the connector—the green or red arrow—from the data source or the previous transformation to the Conditional Split transformation.

  5. Double-click the Conditional Split transformation.

  6. In the Conditional Split Transformation Editor, build the expressions to use as conditions by dragging variables, columns, functions, and operators to the Condition column in the grid. Or, you can type the expression in the Condition column.

    Note

    A variable or column can be used in multiple expressions.

    Note

    If the expression is not valid, the expression text appears in red and a ToolTip on the column describes the errors.

  7. Optionally, modify the values in the Output Name column. The default names are Case 1, Case 2, and so forth.

  8. To modify the sequence in which the conditions are evaluated, click the up arrow or down arrow.

    Note

    Place the conditions that are most likely to be encountered at the top of the list.

  9. Optionally, modify the name of the default output for data rows that do not match any condition.

  10. To configure an error output, click Configure Error Output. For more information, see How to: Configure an Error Output in a Data Flow Component.

  11. Click OK.

  12. To save the updated package, click Save Selected Items on the File menu.

See Also

Concepts

Conditional Split Transformation
Integration Services Transformations
Integration Services Paths
Integration Services Data Types
Data Flow Task
Data Flow How-to Topics (SSIS)

Other Resources

Integration Services Expression Reference
Integration Services Sources
Integration Services Destinations

Help and Information

Getting SQL Server 2005 Assistance