SSIS Table Split to Excel

I have a single SQL Server table and I need a reusable SSIS package that will export it into five separate .xlsx workbooks. Each workbook must hold a different slice of the data, split strictly by rows—­not by columns or filters that change the structure. Here is what I already know: • Source: one T-SQL table in SQL Server 2019 • Output: five Excel Workbook (.xlsx) files, created in one run • Logic: the rows decide which file they belong to (for example, row-range, ID groups, or any other row-based rule we agree on) What I expect from you: • A ready-to-deploy .dtsx package built in SQL Server Data Tools / Visual Studio that performs the split and export in a single task flow • Connection managers configured for both SQL Server and Excel, using dynamic expressions or parameters so I can adjust file paths easily • Brief documentation or a screencast showing where to edit the row-splitting logic and how to schedule the package in SQL Agent I will test by running the package on my environment and confirming that five Excel 2016-compatible workbooks appear with exactly the intended rows and no data overlap. If that check passes, the job is done.

Project ID: 40516763