The following blog post by Atin nicely explains how to go about doing this  http://blogs.msdn.com/biztalkcpr/archive/2009/10/05/inserting-parent-child-records-with-identity-column-using-wcf-sql-adapter-in-one-transaction.aspx.. more »

This post is a follow-up to http://blogs.msdn.com/adapters/archive/2008/06/30/using-the-wcf-sql-adapter-to-read-messages-from-ssb-queues-and-submit-them-to-biztalk.aspx and explains how to push a message using the WCF SQL Adapter from BizTalk to a SQL Service Broker (SSB) queue.   Scenario   1.       An XML message is dropped to a file share .. more »

Today at Microsoft’s Worldwide Partner Conference, we announced availability for BizTalk Server 2009 Enterprise Runtime Edition, BizTalk Server 2009 Standard Runtime Edition, and BizTalk Server 2009 RFID. We recently launched BizTalk Server 2009, which is currently helping customers to integrate business applications and partners and to .. more »

For customers currently using the Microsoft BizTalk Adapters for Enterprise Applications (aka the LOB adapters) and willing to migrate their existing projects to the WCF-based LOB adapters, here's a tool that will help you migrate your projects to work with BizTalk Adapter Pack 2.0. Before we start talking about the tool and the adapter projects it .. more »

It’s been about 48 hours since we released the ESB Toolkit and the news are spreading very quickly. We wanted all the relevant information on this hot topic to be easily discoverable. Following is a set of Frequently Asked Questions regarding the new BizTalk ESB Toolkit 2.0, (this list is also published on the new ESB page on the BizTalk .. more »

As we have pre-announced during several BizTalk sessions at TechEd North America last month, the BizTalk ESB Toolkit 2.0, formerly known as the ESB Guidance 2.0 - has been released today to the web. It is available on the new ESB page in the BizTalk Developer Center on MSDN. This toolkit extends BizTalk Server 2009 capabilities to support a .. more »

I have seen quite a few instances where people run into issues while using the WCF Siebel adapter because of a. Siebel Web Client is not installed correctly on the machine b. Or the URI passed to the adapter, that eventually gets transformed to the connection string passed to Siebel, is incorrect .. more »

In typical Oracle EBS scenarios, it is a common requirement to insert computed values into a table. For example, one might want to populate the key column using a sequence, or insert something like SYSDATE into a date column. However, if the adapter makes it mandatory to provide constant values to be inserted, this becomes impossible to achieve in .. more »

If you are writing a WCF LOB adapter that can be consumed through BizTalk, you need to be aware of certain issues that can manifest because of the way BizTalk interacts with WCF adapters. Some of these can have performance and scalability impact and hence you should consider them when designing/configuring the adapter. Processing in .. more »

BizTalk Adapter Pack team has released a CTP. This is the 5 th CTP and the first one available publicly for everyone to try. The specific enhancements in this CTP are mostly to the OracleDB adapter(included in the BAPv1) to which we added features like support for polling stored procedures and composite operations. We also added 64 bit support .. more »

BizTalk Server 2009 is feature rich, expanding both on platform support and in functionality.. more »