This is what i found
I tested the Stored proc with the 4 CustomerID’s and i am getting the 4 desired xml results.
For the physical
Send SQL Port i set the Receive Pipeline ( this is a solicit-response
port ) to Passthrough instead of XMLReceive
This errors out at the orchestration
On looking at the message details it looks like the message is what i expect it to be and have 4 message parts
I think the XMLReceive is disassembling the incoming message parts and sending only 1(first) message part.
What is a resolution to get all the 4 message parts ? i cannot use passthrough for the orch. receive