"Object cannot be cast from DBNull to other types."

I am getting the following error in one of my integrations. "Object cannot be cast from DBNull to other types." I think this is because in my source the value in NULL, however my target datatype is decimal. I'm guessing there is a problem casting from DBNull to Decimal datatype. Is there a way to add a formula to check for a DBNull value in the source and change it to a different value i.e. 0 or something.

 

Regards,

Jim

(8) Answers

Login