How to populate the resultset returned by tMssqlSP

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 
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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now