How to create xml output with a root tag using SQL Receive port

Home Page Forums BizTalk 2004 – BizTalk 2010 How to create xml output with a root tag using SQL Receive port

Viewing 0 reply threads
  • Author
    Posts
    • #26160

      Hi there

      In my SQL receive port, I am using a select statement with the following format

      select…. from …. where…. order by …. for xml auto, elements

      and the output is as below

      <output><tag1>…</tag1><tag2>…</tag2></output>
      < output><tag1>…</tag1><tag2>…</tag2></output>
      < output><tag1>…</tag1><tag2>…</tag2></output>

      now the problem is that the above output does not have a root tag due to which biztalk generate an error. to receive the output in a schema, i generated that schema using the generated items and used the same above sql statement to create that schema. while creating the schema it also asked to provide the root tag and a target namespace.

      but because of no root tag in the above output, biztalk generate an error that there is no schema specified for this.

      Question: How can I introduce a root tag in the xml above so that biztalk accept it.

      please note: that I have already tried for xml auto, elements, rootbut biztalk does not accept the root word here in the sql statement.

      Any help will be much appreciated.

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