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,468
File size: 196.7kB
Views: 1,346
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.

Add a Comment

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