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:https://www.biztalkgurus.com/biztalk_server/biztalk_blogs/b/biztalk/archive/2006/07/17/how-to-receive-sql-xml-data-into-biztalk-server-2006.aspx