DSXchange

Hi

I have field contract_beneficiary_nomination_comment that has data type varchar and length 8000. I set this field to "NULL" using setnull() function.

When i run the job, I am getting following error.

Can anyone help me?

If I assign a blank instead of null then it works fine.

Thanks
Sri

Can you please show the full error? It was truncated when you used it as your subject line.

The error is

odbcPopulate,0: Fatal Error: Null value on the accessor interfacing to field "contract_beneficiary_nomination_comment".

The message suggests that, on the output link, column contract_beneficiary_nomination_comment is marked not nullable. The error occurs when you try to pass a null to it.