Processing Huge Data From Sql Server

I have a stored procedure (SQL Server 2016) which currently returns 100K to 200K rows based on the parameters to that SP. Each row can be a size of 100KB to 200KB. So total size c

Solution 1:

According to your description, I believe that it represents a good scenario for implementing an SSIS (Integration Services) which can manage and write the final results into a CSV file and allow the customer to exchange it.