Use SSIS to load data in chunks from SQLServer to Excel
This blog provides a solution to use SSIS to load data in chunks from SQLServer to Excel. The sample package has below steps: Read row count of the data to load from SQL Server and save the row count in variable Split the rows to n chunks in a For Loop Container, create an Excel sheet for each chunk and load data in each chunk to Excel sheet
