x

Output of SP to Excel

Hi!
I need to produce an Excel file using the output of approximately 25 SP's in SSIS. I am thinking of creating variables of object type and storing the output of execute sql task in it .So in the final DFT how should I proceed with configuring them as sources? Any other suggestions in how to proceed about with this task
Thanks a lot
more ▼

asked Aug 02, 2013 at 07:10 PM in Default

apple gravatar image

apple
470 10 37 48

This site runs on votes. For all helpful answers, indicate this by clicking on the thumbs up next to those answers. If any one answer lead to a solution, indicate this by clicking on the check box next to that answer.
Aug 06, 2013 at 10:52 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

I am no regular user of SSIS but my preference would be to write out each result set to the Excel file as it completes rather than carry it in memory until the end. If the result sets are large and you have 25 of them then I would personally prefer to get that written to disk as soon as possible.

I dont think it would be too tricky to built a ForEach loop that runs each procedure in turn and then creates a new sheet in your chosen workbook to store the result set.
more ▼

answered Aug 03, 2013 at 08:23 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.3k 75 78 108

(comments are locked)
10|1200 characters needed characters left
more ▼

answered Aug 05, 2013 at 08:07 AM

mjharper gravatar image

mjharper
1.4k 2 4 7

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x927

asked: Aug 02, 2013 at 07:10 PM

Seen: 296 times

Last Updated: Aug 06, 2013 at 10:52 AM