Select from HTTP client adapter <-> XI <-> to MS SQL server

Hi Everybody,

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.

Regards,

Suresh.