SQLTeam.com | Weblogs | Forums

Import data to multiple excel sheets from SQL


Hello All - Could you please share with me the techniques/ best practices to export data from SQL table into a workbook with multiple excel sheets
I am trying to develop a solution as follows
Data resides in SQL tables
Use SSIS to export data to excel template ,which will have the macro to process the report
Fire the macro using script task and post it to share point or email the report

I am stuck with packages where I need to export data into multiple sheets

Please advise


Why not use SSRS for this?