The SQL adapter exchanges data between Microsoft® BizTalk® Server and a SQL Server™ database. You can use the SQL adapter to move individual records from one or more data tables, save the records as one or more XML messages, and pass the message to an application through BizTalk Server. You can also use the SQL adapter to move large amounts of data to or from the SQL Server database as part of a BizTalk Server messaging or orchestration solution. In addition, you can use the SQL adapter to update and delete SQL Server tables by using parameterized SQL statements or stored procedures.
This section contains:
To download updated BizTalk Server 2004 Help from www.microsoft.com, go to
http://go.microsoft.com/fwlink/?linkid=20616.
Copyright © 2004 Microsoft Corporation.
All rights reserved.