Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

How to populate the resultset returned by tMssqlSP

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

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog