BizTalk Gurus
Media » BizTalk Server Samples » BizTalk 2006 Samples » Working with SQL 2005 XML Data Types in BizTalk Server

Working with SQL 2005 XML Data Types in BizTalk Server

Previous | Next | View all files | View Slideshow
Mon, Jul 17 2006
Downloads: 4,950
File size: 196.7kB
Views: 5,967
Working with SQL 2005 XML Data Types in BizTalk Server
Filed under:

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/blogs/biztalk/archive/2006/07/17/How-To-Receive-SQL-XML-Data-Into-BizTalk-Server-2006.aspx

Comments

Arif wrote re: Working with SQL 2005 XML Data Types in BizTalk Server
on Tue, Feb 26 2008 1:56 AM
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) "
Michael wrote re: Working with SQL 2005 XML Data Types in BizTalk Server
on Tue, Mar 11 2008 10:37 AM
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!
Luke wrote re: Working with SQL 2005 XML Data Types in BizTalk Server
on Tue, Mar 11 2008 11:12 AM
Can you post the completed solution? I need this for a POC and dont have time to complete all of the tutorials Thanks,
Romiko wrote re: Working with SQL 2005 XML Data Types in BizTalk Server
on Fri, Mar 14 2008 8:40 AM
Pitty people don't have time to play with you solution, but you make the time for them. Thank you for your sample.
Dino Fassis wrote re: Working with SQL 2005 XML Data Types in BizTalk Server
on Wed, Jul 16 2008 7:30 AM
"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 :-)
claudio wrote re: Working with SQL 2005 XML Data Types in BizTalk Server
on Sun, Jan 11 2009 11:29 AM
thank's!!
Muhammad wrote re: Working with SQL 2005 XML Data Types in BizTalk Server
on Thu, Jan 29 2009 9:13 PM
Michael, Thanks man, you saved my day..

Add a Comment

(required)
 
Spam Control: Type the word BIZTALK2009 here:
(optional)
(required)