Receiving SQL 2005 XML Data in BizTalk 2006
Posted by: Stephen W. Thomas,
on 17 Jul 2006 |
View original | Bookmarked: 0 time(s)
SQL Server 2005 offers many exciting new features. One of them is the support for Xml as a data type. On the surface, this looks great since BizTalk likes Xml. But, we come to learn that the Xml Data Type is not supported using the SQL Adapter inside BizTalk.
But, with a little effort you are easily able to accept Xml Documents that are all in one cell from SQL Server into BizTalk using the Receive Adapter.
Here is the scenario: The client is using a SQL...