Exporting data in two Worksheets in the same Workbook

• arun4.g

  SSC Enthusiast

  Points: 193

  More actions

  December 1, 2008 at 5:19 am

  #202159

  Hi all,

  I have two SQL Queries and I want to run both SQL queries and wants the output in two different Worksheets in Same Excel File.

  I want to do this using SSIS. I need to make it urgently. Thanks

  Can anyone help me in this?

  Thanks

  Arun

• shmuel_v

  Old Hand

  Points: 354

  More actions

  December 1, 2008 at 6:39 am

  #905570

  There is an excelent example at :

  http://rafael-salas.blogspot.com/2008/03/ssis-and-dynamic-excel-destinations_01.html