Archive for

SSIS: Using IF Then Else logic in Derived Columns

A lot of people tend to use a custom script in order to accomplish If Then Else logic simply because the interface for the derived column data object does not have an IF\IIF operator.. In order to place an IF statement for the derived column you would use the following syntax: ({Boolean Expression}?{True Part}:{False Part}) … Continue reading