coalesce function in SSIS

• sachinvinod2k

  Mr or Mrs. 500

  Points: 581

  More actions

  May 29, 2009 at 6:48 am

  #210306

  Is it possible to use the coalesce function in SSIS under the derived column component?

  I guess its not available under derived column component ? Is there any other way to perform this

  Thanks

  kou

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  May 29, 2009 at 7:32 am

  #1002035

  You can use a conditional to simulate COALESCE. Why not do COALESCE in the source query? That would probably be the most efficient way to do it.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• sachinvinod2k

  Mr or Mrs. 500

  Points: 581

  More actions

  May 29, 2009 at 7:52 am

  #1002059

  hello

  Thank you so much. Yes you are right. It didnt strike me. I tried it out and its so easy and perfect.

  Thanks for the suggestion.

  Kou

• Keith Mescha

  Old Hand

  Points: 370

  More actions

  May 12, 2015 at 10:47 am

  #1797334

  How about REPLACENULL( «expression», «expression» )

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  May 12, 2015 at 10:54 am

  #1797336

  Keith Mescha (5/12/2015)

  ---

  How about REPLACENULL( «expression», «expression» )

  REPLACENULL() was introduced with SSIS 2012 and this is a 2005 forum. I still wonder why it took so long to include this function in SSIS.

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2