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

avatar image

apple
750 36 51 59

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

avatar image

Fatherjack ♦♦
43.7k 79 98 117

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

answered Aug 05, 2013 at 08:07 AM

avatar image

mjharper
2k 3 7 13

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

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:

x1147

asked: Aug 02, 2013 at 07:10 PM

Seen: 499 times

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

Copyright 2016 Redgate Software. Privacy Policy