SQL Adapter – Insert/Update multiple records via Stored Proc

I am trying to use the SQL Adapter in BizTalk 2006 to execute a stored procedure that inserts multiple records into a SQL table.

The Response Recv message has been set to the multi-part message type that the adapter wizard created automatically.
However, the orchestration errors out with WrongBodyPart Exceptions

If the procedure inserts 2 records, here’s the error message:
Message_ResCSTRNInsertSQLSP’ has body part ‘BodyPart2’, expected body part ‘BodyPart1’.

Exception type: WrongBodyPartException

If the procedure 10 records, here’s the error message:
Message_ResCSTRNInsertSQLSP’ has body part ‘BodyPart10’, expected body part ‘BodyPart1’.

Exception type: WrongBodyPartException

Everything works fine if the procedure processes 1 record.

Please help.

Thanks
Sridevi