Monday, 1 December 2014

If Else If and else statement in derived column in SSIS

Hi Guys,
Follow the below statement type to achieve if else if condition in ssis

[MyStringVar] == "TEST1" ? "IT WAS TEST1":
[MyStringVar] == "TEST2" ? "IT WAS TEST2":
[MyStringVar] == "TEST3" ? "IT WAS TEST3":
"MATCH NOT FOUND"

No comments:

Post a Comment