Microsoft KB Archive/841119

= There is no option to disassemble result sets for the SQL adaptor that is provided in Microsoft BizTalk Server 2004 =

Article ID: 841119

Article Last Modified on 3/20/2007

-

APPLIES TO


 * Microsoft BizTalk Server 2004 Developer Edition
 * Microsoft BizTalk Server 2004 Enterprise Edition
 * Microsoft BizTalk Server 2004 Partner Edition
 * Microsoft BizTalk Server 2004 Standard Edition

-



SYMPTOMS
When you configure the SQL adaptor that is provided in Microsoft BizTalk Server 2004, you notice that the option to disassemble result sets does not appear. This option is available in BizTalk Server 2002. However, this option is no longer available in BizTalk Server 2004.



CAUSE
By design, BizTalk Server 2004 provides a common way to disassemble results sets for all transports. You no longer have to configure this option on individual SQL adaptors.



RESOLUTION
To resolve this issue, create a custom pipeline. Then, create an envelope schema that can separate the data in any incoming messages into individual documents.



MORE INFORMATION
For additional information about how to disassemble result sets in BizTalk Server 2004, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn2.microsoft.com/en-us/library/ms916019.aspx

For additional information about Microsoft BizTalk Server 2004, visit the following Microsoft Web site.

http://www.microsoft.com/biztalk

Keywords: kbinfo KB841119

-

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

© Microsoft Corporation. All rights reserved.