
	Search KbAlertz Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account

Already have an account?
[Click here to Login]

Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

Ads by Lake Quincy Media

Article ID: 839455 - Last Review: November 30, 2004 - Revision: 1.3

How to disassemble a result set in BizTalk Server 2002

View products that this article applies to.

Expand all | Collapse all

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:

Create an envelope schema that contains the root element of the result data.
Create an <any> element schema.
Set the <any> element schema namespace equal to "##any."
Set the <any> element schema that is named processContents equal to "lax."
Modify the generated schema to remove the root element.

Notice that everything moves up one level.
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.

APPLIES TO

Microsoft BizTalk Server 2002 Standard Edition

Back to the top

kbhowto kbbtsadapters kbinfo KB839455

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate