Microsoft BizTalk Server 2010 Patterns

Processing XML envelopes

If we look carefully at our SQL solution for receiving website orders, we will notice that there is actually a problem with it. In its current form, the solution only works correctly with one order. Clearly, our query is capable of returning more than one record. We could use a TOP 1 clause in the stored procedure to only return one record, but that would be terribly inefficient and not scale well at all. We can also use an envelope to accomplish this.

Envelopes are special schemas that instruct the XML Disassembler to break apart matching messages. The XMLReceive pipeline that we're already using extensively has an XML Disassembler built into it, so this change is relatively easy. This all works through message probing ...