Biztalk Map Runtime Error: Error converting data type nvarchar to numeric

this Error is quite cryptic because it doesnt say which field failed. 

After a long struggle I figured out that it was because of mapping a string element to a decimal element in xml.

it was trying to insert empty string "" into a decimal field.

The way i resolved this was to put a logical numeric functoid , followed by a value mapping functoid which resolved this.

Skip to main content