Integrating Integrators – BizTalk, Windows Azure, Windows Workflow, and Beyond

BizTalk 2006

This group is for all content related to BizTalk Server 2006. This includes a forum, samples, videos, labs, and tools. Most of the content here also applies to other versions of BizTalk beyond 2006.

Working with SQL 2005 XML Data Types in BizTalk Server

Working with SQL 2005 XML Data Types in BizTalk Server

This sample uses a simple stored procedure to extract out data as XML from SQL Server 2005. Using this approach, you can receive many different messages through one Biztalk Receive Location.

This sample will work with BizTalk 2006 and BizTalk 2006 R2.

Get more information from the original blog post on this topic:http://www.biztalkgurus.com/biztalk_server/biztalk_blogs/b/biztalk/archive/2006/07/17/how-to-receive-sql-xml-data-into-biztalk-server-2006.aspx

  • Downloads: 3,823
  • Size: 196.7kB
  • Views: 13,655
  • Comments 7
Rate This
Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment
  • Post
Comments
  • re: Working with SQL 2005 XML Data Types in BizTalk Server

    An error occure when deploying the sample "Error 1 An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) "
  • re: Working with SQL 2005 XML Data Types in BizTalk Server

    Right Click the 'SampleSQLXMLData' solution and go to 'Properties'. Then under the 'Configuration Properties' click on 'Deployment'. Change the server name to where the BizTalkMgmtDb is stored. Cheers!
  • re: Working with SQL 2005 XML Data Types in BizTalk Server

    Can you post the completed solution? I need this for a POC and dont have time to complete all of the tutorials Thanks,
  • re: Working with SQL 2005 XML Data Types in BizTalk Server

    Pitty people don't have time to play with you solution, but you make the time for them. Thank you for your sample.
  • re: Working with SQL 2005 XML Data Types in BizTalk Server

    "gift horse" I Stephen, thaught you may want to know there is a slight inconsistency. The readme says "2. Create a SQL Database named SQLXMLData" The sql file "Create.sql" has a directive "Use SampleXMLData". Easy enough to deal with, just letting you know..... Thaught you might want to know. Not trying to pick holes, especially as all this stuff is put there by you for free :-)
  • re: Working with SQL 2005 XML Data Types in BizTalk Server

    thank's!!
  • re: Working with SQL 2005 XML Data Types in BizTalk Server

    Michael, Thanks man, you saved my day..
Page 1 of 1 (7 items)