coalesce function in SSIS

Question

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

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 · Answer 2

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 · Answer 3

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 4

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