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.