One Star

How to populate the resultset returned by tMssqlSP

Hi,
In my case the procedure which i used in tMSSqlSP gives output of 5 columns as result set. 
Problem : In Propagate QUERY's record set - we can use only 1 column(In my case i have result set of five columns)
so please let me know how to load those 5 columns data to any of the output file or any relational database.?

Thanks in advance 
1 REPLY
Community Manager

Re: How to populate the resultset returned by tMssqlSP

Hi
You need to use tParseRecordSet to parse the result set returned by tMSSQLSP, take a look at the component manual and learn this component.
https://help.talend.com/pages/viewpage.action?pageId=37850948
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business