Question: how to export data to multiple excel sheets?
Answer: Step 1: Create new SSIS Package and create Variables.
ColumnNameForGrouping : Provide the column you would like to use for creating sheet data.
ExcelFileName : Provide the excel file name you would like to create.
FolderPath: Provide the Path where you would like to create excel files.