I am trying to copy data fetched from store procedure (SQL Server) in to Excel file.
Here is what I am doing
TMSSQLSP > tmap > tFileOutputExcel.
On running I get excel generated but only with column names as headers. Getting no data in excel. However if I run the stored procedure in SQL Server it returns the data. I am not sure which setting I am missing.
Please help me.
Solved! Go to Solution.
Thanks for the reply.
I am new to Talend. This is my second day not sure how to share the design. I am attaching a screen shot of the designer. Hope it helps.
Can you please tell me how design could be shared? Did you mean i export the job to my hard drive and then zip that folder and upload it?
Just make a screen capture for the design and for the main components settings if necessary then inclure these captures in your post using the camera on top of the field where you enter your post
Design screen shot is already shared. Here are the screen shots for main components settings.
Since you are not getting data from tMSSqlSP.can you share tMSSqlSP screenshot that the parameters defied in Bassic setting?
Today changed my job design I added new component tFixedFlowInput from which I passed the parameter of type recordset to tMSSqlSP and it worked.
I have attached revised layout of the job for your reference. Please let me know if this fine.
Just for your reference I followed url https://community.talend.com/t5/Design-and-Development/How-to-pass-date-value-embedded-within-single...
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.