CODEWITHSUNDEEP
sql-serversql-server-2008ssis
user1169594
user1169594

Reputation: 63

How to convert IF expression in sql to Derived column in SSIS

If(HampPRAPrinForg = 2, If(PrincipalForgive = 1, true, false), 
    If(HampPRAPrinForg = 1, true, 
       If(HampPRAPrinForg = null_integer, null_boolean, false))

Upvotes: 0

Views: 2159

Answers (1)

David Benham
David Benham

Reputation: 1174

(HampPRAPrinForg == 2) ? (PrincipalForgive == 1 ? true : false) : (HampPRAPrinForg == 1, true, (HampPRAPrinForg == null_integer ? null_boolean : false))

Upvotes: 4

Related Questions