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

The information in this article 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://msdn.microsoft.com/library/default.asp?url=/library/en-us/operations/htm/ebiz_prog_adapt_ynaa.asp

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

http://www.microsoft.com/biztalk

Modification Type:	Major	Last Reviewed:	12/10/2004
Keywords:	kbinfo KB841119 kbAudDeveloper kbAudEndUser