Make sure you create WCF-SQL adapters against the target database Do not use stubs A stub generates metadata that may be different The Microsoft BizTalk
I think the answer is no unless you are prepared to accept the risk of duplicates and/or lost messages Let me explain why below This is a summary of
WCF SQL adapter error: System.Data.SqlClient.SqlException: Maximum stored procedure, function, tr...
Last week I started to get this error in one of the solutions that I had developed The solution had been working fine and all of a sudden in UAT this error
Recently one of my colleagues came to me with this problem and I pointed him in the direction of Thiago’s article on the WCF SQL adapter A little while later
I was trying to help a newbie developer with the WCF adapter today and got stumped for awhile by the above problem They were using BizTalk 2006R2 and were
If you use the the WCF adapter wizard to generate the schema from the stored procedure then the XML data type is now of string type in the result set schema
I got an amusing call from a DBA the other day saying that the BizTalk SQL adapter was failing whenever he sent through a message that had an apostrophe in