Stored procedure results to multiple excel sheets of same workbook using SSIS
<p>I have to export the SQL server data to Multiple sheets of same workbook. 
This is my requirement.</p>

<p>I have 3 select stored procedure (I am using SQL server 2014) and each stored procedure will return 3 different data sets. I need to export these 3 result sets in to 3 different sheets of same excel file. (For example, Sheet1 contains result sets of stored procedure 1, Sheet2 contains result sets of stored procedure 2 and Sheet3 contains result sets of stored procedure 3). </p>

<p>How can I do this? I will have to schedule this process in sql server agent</p>

<p>I have tried the below code but it did not work for me.  </p>

<pre><code>insert into OPENROWSET(
   'Microsoft.Jet.OLEDB.4.0', 
   'Excel 8.0;Database=d:\export\sales.xls;;HDR=YES', 
   'SELECT * FROM [Sheet1$]')
select * from sales_part1
</code></pre>

<p>Please help me. </p>