Schema Design Patterns: Russian Doll

I am working on a BizTalk solution which uses a schema that was hand created using XML Spy.  The schema was created in such a way in which everything was globally available and when I brought it into the BizTalk editor the schema looked to have 266 root nodes.  Needless to say this spurred many…

8

BizTalk MSMQ Adapter and the MsmqAdapterProperties.dll

I have been working on an application which needs to send a message to a queue in which the queue location was contained in the incoming XML Message.  This was simple as you can just set the send port binding to Dynamic and provide the address through a distinguished field using an expression shape and…

0

MSMQ adapter error if MSMQ/C adapter was installed

My client had a preview of the MSMQ/C adapter and was using it in their development environment.  When the new MSMQ adapter came out they installed that and promptly received the following error:   The Messaging Engine failed to create the receive adapter “MSMQ”. Reason: “Could not load type Microsoft.BizTalk.MsmqAdapter.MsmqReceiver, Microsoft.BizTalk.Adapter.MSMQ.MsmqAdapter,   We were able…

0

Using SQLXML’s at-identity with BizTalk

I was looking for a way to send data to SQL Server to populate multiple tables in a parent-child relationship without the need to make additional roundtrips.  What I describe below is the solution that I put together.   The first thing that I found was that SQL XML has the ability to do this…

10

SQL Adapter, Updategrams and Multiple Tables

  When using the SQL Adapter, it provides the ability to auto generate an Updategram schema based on the table that you want to manipulate.  To do this, run the wizard and specify the Updategram option and then choose the table name and columns to include in the generated schema.  After you do this you…

2