Question: how to export sql server data into multiple excel sheets?
Answer: Configure OLEDB Connection [Countries] table and divide it into multiple sets and store it into different worksheets. To do that, we should add a Data Flow task in our Control Flow. Drag the Data Flow Task from Favorites to the Control Flow and rename it to “Export Data to Excel Worksheet”, as shown in the below image.