Strange mapping behaviour with SQL schema

Home Page Forums BizTalk 2004 – BizTalk 2010 Strange mapping behaviour with SQL schema

Viewing 1 reply thread
  • Author
    Posts
    • #19090

      Hello,

      first the szenario:

      I fetch data from a SQL database, the schema for the receive pipeline I have created with the SQL adapter schema wizard. In the next step I have a construct message with a transform shape inside, in the mapping of the transform shape I want to map data form the incoming schema (that means from the SQL schema) to an arbitrary other schema.

      But the created message only contains the root nodes of the destination schema, all childnodes are not present, and of course no values from the incoming message are mapped.

      Did anyone else know this problem, too?

      Is there a workaround or have I a configuration failure in my schemas?

      P.S. the incoming message is not empty!!!!

      Regards

      Peter

       

    • #19136

      Hey Peter,

      Just throwing this out there…did you happen to remove the ‘FOR XML…’ clause after your schemas were generated?

      -Rich

      • #19146

        Hi,

        I found the failure the ELEMENTS command was too much 

         

        — for schema generating

        –for xml auto, xmldata

         

        –for normal:

        for

        xml auto –, ELEMENTS

         

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.