Hi @m
For information on using SSIS to import data from Excel or export data to Excel, you can check out this document: Import data from Excel or export data to Excel with SQL Server Integration Services (SSIS).
Here is a blog that uses SQL Server Integration Services to export SQL Server data to an Excel worksheet: https://www.mssqltips.com/sqlservertip/5324/export-sql-server-data-to-multiple-excel-worksheets-using-sql-server-integration-services/. Maybe you can use it as a reference.
Hope these can help you.
If the answer is helpful, please click Accept Answer
and Up-Vote
for the same. If you have any questions, please feel free to let me know.
Best regards,
Aniya