title: how to create dynamic excel sheets based on table data
body: <p>Given one table in SQL Server which holds consolidated data from three source tables including one column called OFFICE which differentiates the records from each other.</p>
  
  <p>The three source tables hold data from three offices.</p>
  
  <p>I want to create an Excel file dynamically which will have 3 sheets in one workbook based on the three different different offices (ex. office1, office2, office3) resulting in each sheet containing the relevant data according to its office.</p>
  
  <p>Please recommend an approach using dynamic Excel destination in SSIS as I don't want to use an approach which creates a template file and then copies that template to destination excel file.</p>