Biztalk Discoveries, Experiences

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 Read More...

Posted Wednesday, August 27, 2008 6:20 PM by Sundara Prabu .T | 0 Comments

Biztalk Map Input xml Node Exists ?

Today I figured out the easiest way to Map a xml node to a destination node only if source node exists. if the source node doesnt exist, the destination node doesnt get created at all in the output xml. No need of any functoids. just Drag a map link from Read More...

Posted Tuesday, June 10, 2008 3:07 PM by Sundara Prabu .T | 1 Comments

Error btm1010: the Scripting functoid

error btm1010: the "Scripting" functoid has 3 input parameter(s), but 0 paraneter(s) are expected. when i referenced an external assembly which had the helper method, which was called from a biztalk map it does need 3 inputs and they are defined, this Read More...

Posted Wednesday, February 06, 2008 10:26 AM by Sundara Prabu .T | 1 Comments

Webservices from functoids (btm) thro Proxy server

we had a requirement where we had to call webservices from a btm biztalk map. the script functoid called an external assembly which in turn called a 3rd party webservice on the internet. this required a proxy server since it is on the internet. this is Read More...

Posted Thursday, January 10, 2008 7:48 AM by Sundara Prabu .T | 1 Comments