Hi!
In my dtsx, I make lookup's to several tables to see if some values exists there. In order to update my destination table, I use derived column and I've edited like this:
Derived Column Name: fieldexists
Derived Column: replace "fieldexists"
Expression: ISNULL([OutputLookup]) ? "False" : "True"
Data Type: Boolean [DT_BOOL]
The package runs smoothly and does what I want but the problem is that de field "fieldexists" is updated with the "True" value whenever is true, but whenever is false, it is not updated (it remains null).
Thanks for any help.