I am trying to do a SELECT from MS SQL server DB.
My DT MT and everythigs fine...Only that i dont get back my resultset in the result section of the HTTP client adapter.
In sxmb_moni both the request and the response message show chekkered flag.
In the Response Message i can see the row returned in the <b>XML Message -> Call Adapter -> Payloads -> Main Document(application/xml)</b>
But am not able see the same row in <b>XML Message -> Request Message Mapping -> Payloads -> Main Document(application/xml)</b>
Please help me out.