Microsoft KB Archive/839455

= How to disassemble a result set in BizTalk Server 2002 =

Article ID: 839455

Article Last Modified on 11/30/2004

-

APPLIES TO


 * Microsoft BizTalk Server 2002 Standard Edition

-





INTRODUCTION
You can put the output of an SQL query in a separate XML file by using the Disassemble Result Set option in SQL Adapter. You can do this instead of putting the output of an SQL query in one large XML file that contains many records. You can do this in Microsoft BizTalk Server 2002.



MORE INFORMATION
To disassemble a result set, use the SQL Receive Location component with the XML receive pipeline. Alternatively, you can use a custom pipeline that contains the XML Disassembler pipeline component. To divide the schema that is created by the Add Generated Items Wizard into two schemas, follow these steps:
 * 1) Create an envelope schema that contains the root element of the result data.
 * 2) Create an   element schema.
 * 3) Set the   element schema namespace equal to &quot;##any.&quot;
 * 4) Set the   element schema that is named processContents equal to &quot;lax.&quot;
 * 5) Modify the generated schema to remove the root element.

Notice that everything moves up one level.
 * 1) Set the Body XPath property of the root element equal to itself.

Important Make sure that the envelope schema and the document schema have the same target namespace.

Keywords: kbhowto kbinfo kbbtsadapters KB839455

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.