topic Unable to get the result from the sp using tparserecordset in Talend Studio

Unable to get the result from the sp using tparserecordset

Anonymous — Sun, 26 Feb 2017 19:03:47 GMT

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

Re: Unable to get the result from the sp using tparserecordset

Anonymous — Mon, 27 Feb 2017 05:12:22 GMT

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

Re: Unable to get the result from the sp using tparserecordset

Anonymous — Mon, 27 Feb 2017 13:42:39 GMT

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.

Re: Unable to get the result from the sp using tparserecordset

Anonymous — Tue, 28 Feb 2017 06:53:39 GMT

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

Re: Unable to get the result from the sp using tparserecordset

Anonymous — Tue, 28 Feb 2017 13:49:43 GMT

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.