SSIS Conditional Split Transformation

Task Factory Loews Corporation

"We bought the product mostly because of the company's reputation for the service they provide and the specific need of a secure SFTP task."

Matt Cushing

Application Systems Analyst/Developer

Loews Corporation

Greater New York City Area

Task Factory - Mark Marinovic

"We bought Task Factory primarily for the SCD Type 2 task, as it enabled us to do several things the built-in SSIS SCD task did not do. Task Factory comes highly recommended from me as our ROI was reached in just days."

Mark Marinovic

Task Factory - Urban Outfitters

"We have found that Task Factory tremendously speeds up the development process and improves performance by means of the high-performance components."

Tim Harris

BI Data Engineer

Urban Outfitters Inc.

Buy Now Free Trial Download Compare Editions

Task Factory Advanced Conditional Split Transform

The Advanced Conditional Split extends and replaces the native SSIS Conditional Split to allow you to use our expanded Expression Engine and its 180+ functions to create conditional splits in your dataflow.

Feature Highlights

Extended Expression Library allows the user to create new conditions based on expressions not available in SSIS.
Expression Engine supports multi-line expression which allows for more complex conditions to be created.
Unit Tester that comes with the expression editor allows the user to test the condition expression before running the package.
Expression reusability allows the user to define an expression and reuse it in other derived conditions.

Advanced Conditional Split Transform

Advanced Conditional Split Transform- Step 1

The configuration editor for the advanced conditional split is similar to an expression editor. Here, users can select the variables and columns to use in the transform as well as over 180 functions.

Advanced Conditional Split Transform- Step 2

To configure the component, create a name for the conditions and then write the expression in the ‘Expression’ field.

Advanced Conditional Split Transform- Step 3

Click ‘Validate All’ at the bottom of the editor to make sure all the expressions are written correctly.

View Our Suite of Pragmatic Works Products