Unable to get the result from the sp using tparserecordset

[Anonymous]

Hi,
I am trying to fetch the output from the sp using parsesetrecord. But I am getting the result as attached. 
Please let me know if something is missing in my design. Help appreciated.
Thanks

[Anonymous]

Hi  
You should define the real column names on tParseRecordset component, for example, assuming the recordset contains id and name value, you should define ID and name column, and set its Value as "id" and "name".

Regard
Shong

[Anonymous]

Hi Shong,
The stored proc will return only one column as output, screenshot attached. So I just need the to capture the output from xml_document column. I do not want to parse it.

[Anonymous]

What's data type of return column? Try to set it as string rather than record_set and you don't need tparseRecordSet component. 

[Anonymous]

Hi Shong, 
Thanks for the reply.
The data type of the output is varchar. I changed it as you suggested, but it throws the following error as shown in attached image.
Please let me know of I need to change any settings in the tmssqlsp component.