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