Five Stars

Issue Copying Data From Stored Procedure Into Excel

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Nine Stars

Re: Issue Copying Data From Stored Procedure Into Excel

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

Manohar B
9 REPLIES
Thirteen Stars TRF
Thirteen Stars

Re: Issue Copying Data From Stored Procedure Into Excel

Can you share your job design?


TRF
Five Stars

Re: Issue Copying Data From Stored Procedure Into Excel

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.

 

Five Stars

Re: Issue Copying Data From Stored Procedure Into Excel

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?

 

Thirteen Stars TRF
Thirteen Stars

Re: Issue Copying Data From Stored Procedure Into Excel

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


TRF
Five Stars

Re: Issue Copying Data From Stored Procedure Into Excel

Hi,

 

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

 

Five Stars

Re: Issue Copying Data From Stored Procedure Into Excel

Here is the screen shot for Excel file Component Properties.

 

 

Nine Stars

Re: Issue Copying Data From Stored Procedure Into Excel

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

Manohar B
Five Stars

Re: Issue Copying Data From Stored Procedure Into Excel

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

Nine Stars

Re: Issue Copying Data From Stored Procedure Into Excel

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

Manohar B