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

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial