I need another set of eyes.
I have a Derived Column Transformation set up in a package in SSIS 2008. I want to replace any nulls with a value of 0, or else pass the existing UrgencyId on through the expression.
Here is the expression that I am using:
ISNULL(UrgencyID) ? 0 : UrgencyID
However, when I check results in a DataViewer on the other side of this transformation, I still have a value of null in one record. UrgencyId is a four-byte signed integer. Any ideas?
Please let me know if I need to provide additional details.