Issue Copying Data From Stored Procedure Into Excel

[Anonymous]

Hi,

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.

Regards

Tarunjit Singh

[TRF]

Can you share your job design?

[Anonymous]

Hi,

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.

Issue.png

[Anonymous]

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?

[TRF]

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

[Anonymous]

Hi,

Design screen shot is already shared. Here are the screen shots for main components settings.

TMSSQLSP Component Properties.png

[Anonymous]

Here is the screen shot for Excel file Component Properties.

ExcelFileOutPutProperties.png

[manodwhb]

Since you are not getting data from tMSSqlSP.can you share tMSSqlSP screenshot that the parameters defied in Bassic setting?

[Anonymous]

Hi,

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

Regards

Tarunjit Singh

JobLayout.png

[manodwhb · Accepted solution]

You can design in this way also,you got all records into output file right?