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.