I'm having a problem returning multiple records in the adapter for sql using the disassemble result set. It will return 110 records but not 115. (see error below) I ran a trace but did not come to any conclusions with it. I also set the timeout value to 90 which didn't seem to change anything. Is there another setting in the component or elsewhere I can change to get this to work for a couple thousand records?

- - - - - - - - - - -
ERROR MSG
- - - - - - - - - - -
Event Type: Error
Event Source: RFSQL
Event Category: None
Event ID: 10
Date: 7/19/2004
Time: 10:05:58 AM
User: N/A
Computer: BIZ
Description:
A worker thread reported a failure: [Error:] An error occurred in BizTalk Server.

 Details:
 ------------------------------
 Unable to enlist in the transaction.

 There was a failure creating the internal work item. Make sure that SQL Server is running.


  [Source:] [HelpFile:] [HelpContext:] 0

Note: The Disassemble result set feature can not be used if the target SQL Server is the same one that BizTalk uses. In this case you must unselect the Disassemble Rresult Set feature.
The error code is shown in the data area below.
The operation was: ISQLWorker->Execute


**
thanks,
Phil
**

__________________
**
thanks,
Phil
**

What I ended up doing was creating a separate specification for the envelope using Editor. In this spec, I set the envelope property in the Reference tab to 'yes' and checked the Document Container Node in the Dictionary tab on the root element.

I have the envelope specified in the Routing properties for the SQL Adapter job. My test of 1000 records produced 1000 documents just like I wanted and validated successfully against my original spec.

**
thanks,
Phil
**