Microsoft BizTalk Adapter for SQL Server

The WCF based SQL Adapter can be used to connect BizTalk applications to SQL Server
  • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.


    File Name:

    Microsoft BizTalk Adapter for SQL Server.exe

    Microsoft BizTalk Adapter for SQL Server x64.exe

    Date Published:


    File Size:

    4.0 MB

    4.1 MB

      This SQL adapter which is also a part of the BizTalk Adapter Pack 2.0 can be used to connect BizTalk applications to SQL Server. The adapter replaces the current native SQL adapter and offers many more features.
      • Insert/Update/Delete/Select operations on tables and views

      • Invoke (SQL and CLR) Stored procedures, scalar valued functions , table value functions

      • Supports execution of generic T-SQL statements, via the ExecuteReader(), ExecuteNonQuery() and ExecuteScalar() operations

      • Configurable polling – polling statement, polling interval, receive multiple result sets

      • Support for x86 and x64 platforms

      • Support for new data types in SQL2005 and SQL2008 (notably FILESTREAM, varbinary (max))

      • Support for UDTs

      • Ability to pass table value parameters

      • Composite operations - invoke operations on multiple tables and call any number of stored procedures in the same transaction

      • SQL query notifications

      • Ability to directly call stored procedures which used the ‘for xml’ style supported by the BizTalk 2006 SQL adapter to ease backward compatibility

      SQL Server versions supported SQL 2000, SQL 2005, SQL 2008 In order to use this adapter and be eligible for support you must have a valid BizTalk Server license.
  • Supported Operating System

    Windows Server 2003 Service Pack 2, Windows Server 2008, Windows Vista, Windows XP Service Pack 3

      • Windows XP SP3

      • Windows Server 2003 SP2

      • Windows Server 2003 R2

      • Windows Server 2008

      • Windows Vista

      • .NET 3.5 SP1

    • Please note that this adapter is offered as a supplement to BizTalk Server 2009. You must have a valid license for the BizTalk Server in order to use the SQL adapter and be eligible for support and to recieve updates
Site feedback

What category would you like to give web site feedback on?

Rate your level of satisfaction with this web page today: