hi..
when doing a lookup on a nullable field, I am getting the following error..
When binding output schema variable "outRec": When binding output interface field "XXXX" to field "XXXX": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted.
Can you give me suggestions how to get rid of the warning...
Thanks,
Venkat
lookup on null field giving warning
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
It is giving error because you are sending the column with out handling its null values.Either use IsNull() or NulltoEmpty() in the transformer stage or handle_null() in the modify stage for that particular field before doing lookup.
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
Thomas Alva Edison(1847-1931)