warning

satya99 · Post by **satya99** » Thu Jan 04, 2007 3:15 pm

Hi,

when i am performing a lookup i am getting this error, job design is

odbc
|
odbc----->lkp------>target

I am getting the following error:

LKP,0: When binding input interface field "xyz" to field "xyz": Converting nullable source to non-nullable result;
fatal runtime error could occur (use a modify operator to specify value to which null should be converted)

Any suggestions.

Thanks in advance

I_Server_Whale · Post by **I_Server_Whale** » Thu Jan 04, 2007 3:18 pm

You would have got a solution if you had searched. Do and exact Search on "Converting nullable source to non-nullable result".

Here's one to start with.

ray.wurlod · Post by **ray.wurlod** » Thu Jan 04, 2007 4:04 pm

This isn't really a server job, is it?

kumar_s · Post by **kumar_s** » Thu Jan 04, 2007 4:13 pm

Hi,
The log pretty much gives out the cause and the solution.
You lookup LKP is trying to Converting nullable source to non-nullable result;
fatal runtime error could occur. So you can use a modify operator to specify value to which null should be converted. Basically some of your field is been converted from Nullable to Not Nullable.
As mentioned, it has been dealt several time, so do a search before posting it.