topic Re: Issue Copying Data From Stored Procedure Into Excel in Talend Studio

Issue Copying Data From Stored Procedure Into Excel

Anonymous — Wed, 07 Feb 2018 10:01:43 GMT

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

Re: Issue Copying Data From Stored Procedure Into Excel

TRF — Wed, 07 Feb 2018 10:03:55 GMT

Can you share your job design?

Re: Issue Copying Data From Stored Procedure Into Excel

Anonymous — Wed, 07 Feb 2018 10:08:14 GMT

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

Re: Issue Copying Data From Stored Procedure Into Excel

Anonymous — Wed, 07 Feb 2018 10:21:09 GMT

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?

Re: Issue Copying Data From Stored Procedure Into Excel

TRF — Wed, 07 Feb 2018 10:25:32 GMT

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

Re: Issue Copying Data From Stored Procedure Into Excel

Anonymous — Wed, 07 Feb 2018 11:15:49 GMT

Hi,

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

TMSSQLSP Component Properties.png

Re: Issue Copying Data From Stored Procedure Into Excel

Anonymous — Wed, 07 Feb 2018 11:16:56 GMT

Here is the screen shot for Excel file Component Properties.

ExcelFileOutPutProperties.png

Re: Issue Copying Data From Stored Procedure Into Excel

manodwhb — Thu, 08 Feb 2018 07:34:26 GMT

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

Re: Issue Copying Data From Stored Procedure Into Excel

Anonymous — Thu, 08 Feb 2018 07:57:10 GMT

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-quotes-to-call/m-p/38069#M10407

Regards

Tarunjit Singh

JobLayout.png

Re: Issue Copying Data From Stored Procedure Into Excel

manodwhb — Thu, 08 Feb 2018 09:19:27 GMT

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