Multipart Messages and the SQL Adapter

The integration scenario that I am trying to address is as follows: I expect to receive a message that consists of a collection of simpler message types. I would like to transform this message into a multipart message, and insert them into SQL using a stored procedure. The problem is that the raw data that I receive may contain some simple messages that I have already received. I would like to receive a single message back from SQL that contains an \”Updated\” flag for each instance of the stored procedure instance, so that I can eliminate the duplicates, from downstream processing.

So far I can perform multiple inserts using the multipart message, but I only receive the \”Updated\” message from the stored procedure, for the first execution of the stored procedure. I have no errors or warnings in the event log, so I assume that every thing works as intended. Can anyone provide guidance?