SSIS Package to export a stored proc result sets to different sheets in Excel file

• reju.ravindran211

  SSC Journeyman

  Points: 75

  More actions

  July 9, 2015 at 4:58 am

  #299884

  I want a stored proc which results multiple result set and i ant to put the resultset in different sheet of an excel file.

  i googled and got info of writing a script component which results in multiple result set but how do i map to different sheets of an excel

  http://www.codeproject.com/Articles/32151/How-to-Use-a-Multi-Result-Set-Stored-Procedure-in

  or Is there any other way to do it?? by using for loop container?? Please help.

• Tim Mitchell

  SSCoach

  Points: 15695

  More actions

  August 1, 2015 at 7:55 am

  #1816614

  I recently wrote this blog post[/url] in which I reference the article you mentioned, and I show how to use code to handle multiple result sets. It's not specific to Excel, but you could probably adapt it to fit that purpose.

  Tim Mitchell
  TimMitchell.net | @tmitch.net | Tyleris.com
  ETL Best Practices