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