Friday, December 21, 2007

SSIS Derived Column IIF/IF Expression

This is for my memory, but I figure if I have a hard time remembering, maybe someone else will...

For those of you who are trying to remember how to do IF/IIF functionality in the SSIS Derived Column control:
({comparison} ? {truepart} : {falsepart})
So, if I want to evaluate the similarity from a fuzzy lookup, it would look like this:
(_Similarity > .78 ? ID : "")


Maybe someday Microsoft will standardize all of the expression languages in their BI tools!

peace

4 comments:

Anonymous said...

Thanks, I'm always forgetting this too, and often have to come back here to get reminded.

Bob Pearson said...

Thanks for the feedback... it's good to know people read this!

Bob

Anonymous said...

Thanks for the info!

Anonymous said...

thanks