*Download size depends on selected download components.
Overview
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
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.
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
