Export data to Excel using a SP as DataSource

• kvishu83

  SSC Eights!

  Points: 848

  More actions

  November 1, 2011 at 1:55 am

  #262181

  Hi,

  I got a request to export data to excel sheet using a stored procedure as datasource. Execution of this sp will results multiple result sets and I want to export each result set in separate sheet. Any help will be appreciated

• kvishu83

  SSC Eights!

  Points: 848

  More actions

  November 1, 2011 at 9:39 pm

  #1401964

  Any one got this type of request?

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  November 2, 2011 at 2:09 am

  #1401999

  Here you go:

  http://www.codeproject.com/KB/database/SSISMultiResultSet.aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP