Saturday 23 January 2010

SSIS Data Flow : Conditional Split examples

Examples and syntax of how to use the Conditional Split Transform in a data flow >

Example 1 :

Formatting a condition goes like this>

[Action] == "New Configuration"
[Action] == "Deleted Configuration"
[Action] == "Changed Configuration"

(Action is a column name in this data flow)

Example 2:



Condition in use here is LTRIM(City) == "" || LTRIM(State) == ""
(where || means OR)

No comments: