Exporting 30 query output to Excel spreadsheet

• athi_ssn

  Old Hand

  Points: 328

  More actions

  February 7, 2013 at 4:01 pm

  #273916

  Hi All,

  I am new to SSIS and am currently working on a requirement as follows:

  We have 30 sql scripts which queries various tables and gives the errors for each packages we have. We manually copy the script outputs to separate tabs in an excel sheet and send it to our clients. I am working on automating this using SSIS. So right now I have created a package which runs one sql script and writes to excel file tab. So to output 30 script results do I have to implement the above solution 30 times or is there any optimum way of implementing them?

  Any suggestions would be welcome.

  Thanks,

  Athi.

• aaron.reese

  SSChampion

  Points: 13498

  More actions

  February 12, 2013 at 9:56 am

  #1587093

  What changes between the 30 scripts?

  If it is just the table names then I would look for a ForEach loop solution.

• Phil Parkin

  SSC Guru

  Points: 246970

  More actions

  February 13, 2013 at 6:56 am

  #1587434

  This is a cross-post - no more answers here please - use this thread instead.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel