SQLTeam.com | Weblogs | Forums

ISNULL in Derived Column


#1

This is an example of a sql case statement,
Case when ID='30'
and Value = ' burger''
then 'Lunch'
else 'Dinner'

How do I write this Case statement using ISNULL or IFF function in SSIS Derived Column...I want the Values to dynamically update at runtime.

Thanks in advance for your help