Using a SQL Adapter in BizTalk Server 2004
By Mauricio Ritter
This article is a how-to guide to using SQL Server adapters in BizTalk Server 2004. It'll show how to configure the ports, messages, and orchestrations to use this BizTalk resource.
SOURCE URL:
http://www.codeproject.com/biztalk/usingsqladapter.asp