Case statement in SSIS

• JoyKing

  Ten Centuries

  Points: 1106

  More actions

  August 1, 2011 at 1:16 pm

  #245382

  Hi All,

  How can I achieve below case statement in SSIS derived column transformation.

  CASE WHEN B='N' THEN ISNULL(C,D) ELSE F

  Do let me know if any other suggestion.

  Thanks in advance,

  Joy

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  August 2, 2011 at 4:02 am

  #1362018

  Here you go:

  ( == "N") ? (ISNULL([C])? [D] : [C]) : [F]

  I made the assumption that all columns have the same datatype. If not, you'll need to add some typecasting.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP