Replace null value in the field with another field value : NOt working

• komal145

  SSCrazy Eights

  Points: 9892

  More actions

  December 18, 2019 at 7:47 pm

  #3708894

  Hi Here is what i am trying to achieve

  if "Lob_mt"  field  is null then replace it with field "lineofbuisness" value.

  using this expression in derivedcolumn transformation

  isnull(LOB_mt)==True ? (line of business):lob_mt

   

  it is not working . note: i am using SSIS 2008 so, replacenull function is not an option

   

• Site Owners

  SSC Guru

  Points: 80338

  More actions

  December 19, 2019 at 8:10 pm

  #3709246

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.