As mentioned in this post, we’re developing a new SQL Adapter, which will be available in the next release of the BizTalk Adapter Pack. The list of features which we’re supporting is mentioned in that blog post.

As for the features/items/etc which we’ve decided NOT TO SUPPORT, they are:

  • SQL Server versions prior to SQL 2005.

  • The ability to perform one or more INSERT, UPDATE and DELETE operations, on one or more tables, all within the same XML message. In our current design, within a single message, you can either perform one or more INSERT, or UPDATE, or DELETE operations, all on the same TABLE or VIEW.

  • The ability to have multiple transactional blocks within the same XML message. All the operations within a message all take place within the same transaction; and this is actually a distributed transaction which spans these operations on your SQL Server, as well as the operations performed by BizTalk on the MessageBox database.

If any of the above are absolutely critical to your scenarios, please get in touch with us.

EDIT: Regarding the first two points, please have a look at this post.