Teamplayer or not? BizTalk 2006 & Sql Server 2005

Hi all!

I have a very surprising problem. I have worked for some time with the SQL Server 2005 SOAP endpoint. Until now everything worked really good. In a new project together with BizTalk 2006 my job is the receive wmq messages with BizTalk 2006 (XML) and save them into SQL Server 2005 tables. As I am really happy with BizTalks way of consuming webservices and happy with SQL Server 2005 SOAP endpoints I thought “yeah – join the power of both!”.

What I’ve done:

1) Create all the basic stored procedures (very simple – only “insert into” stuff).

2) Create the necessary SOAP endpoints.

3) Add the web reference to my BizTalk 2006 project.

4) BizTalk creates the multipart messages.

Now I have the schema and message from the inbound-message (xml) and the multipart-message auto-created by the web reference. Now the problem: The BizTalk mapper does not show/allow the multipart message as source or target message-schema.

When I go ahead using the assignment shape and use inline code to set the outbound-message-fields it works. This is ok for 2 to 3 fields but I have 14 messages with up to 20 fields in it … ;-(

Is there any solution for this? If not I am really wondering because these two products seems to be very tight to eachother.

Thnx a lot for your help!

Cheers

Hanso