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
07-17-2006
Downloads: 3,818
File size: 196.7kB
Views: 2,378
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 02-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 03-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 03-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 03-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 07-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 :-)

Add a Comment

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