Re: SQL Adapter – returning only the first response….not returning all responses

You are sending multiple stored procedure calls to the adapter at once.

The adapter returns one body part per query it has run.

BizTalk will only show you the first message body part.  You will need to iterate through the parts in the message to access all results.