Issue Copying Data From Stored Procedure Into Excel

Highlighted
Seven 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

 

 


Accepted Solutions
Forteen 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
Don't forget to give kudos/accept the solution when a replay is helpful.

All Replies
Fifteen Stars TRF
Fifteen Stars

Re: Issue Copying Data From Stored Procedure Into Excel

Can you share your job design?


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

 

Seven 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?

 

Fifteen Stars TRF
Fifteen 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
Seven 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.

 

Seven Stars

Re: Issue Copying Data From Stored Procedure Into Excel

Here is the screen shot for Excel file Component Properties.

 

 

Forteen 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
Don't forget to give kudos/accept the solution when a replay is helpful.
Seven 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

Forteen 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
Don't forget to give kudos/accept the solution when a replay is helpful.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog