[resolved] Need result set from stored procedure sent to file, how do I

One Star

[resolved] Need result set from stored procedure sent to file, how do I

I need to call a stored procedure and have the result sent to an Excel spreadsheet, Am trying to use tMSSqlSP to call procedure, but don't know how to get result set into Xcel or any other file. DO I need to use another component?

Accepted Solutions
Seventeen Stars

Re: [resolved] Need result set from stored procedure sent to file, how do I

hi,
check "is function" option that'll open another option "return result ..."
here 's an example with Oracle :
https://help.talend.com/reader/B1UNGSOHwo6kbGrUQpis7A/glBoX0eKG03mBczkAx0j5Q
regards
laurent


All Replies
Five Stars

Re: [resolved] Need result set from stored procedure sent to file, how do I

Hi Ounger,
In some instances we use a stored procedure to select the data that gets loaded into a .csv file. Below is an overview of what we do. Please note that we use MySQL as our database but the below should still translate.
Our job will call a stored procedure using a tMySqlInput component to select the data (the call to the stored procedure is made via the query property on the Basic settings tab), use a tMap component to map the columns from the stored procedure call to the .csv (in our case) file, and a tFileOutputDelimited component for the output.
Note that we have Advanced Settings tab on the tMySqlInput component carrying the column definitions for the selected data defined on that tab and these defined columns serve as input to the above mentioned tMap.
In a nutshell... tMySQlInput -> tMap -> tFileOutputDelimited.
Hope this helps and let me know if you need additional information.
Regards,
Tom
Seventeen Stars

Re: [resolved] Need result set from stored procedure sent to file, how do I

hi,
check "is function" option that'll open another option "return result ..."
here 's an example with Oracle :
https://help.talend.com/reader/B1UNGSOHwo6kbGrUQpis7A/glBoX0eKG03mBczkAx0j5Q
regards
laurent