Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vishal.todkar
Starting Member
20 Posts |
 Posted - 2010-05-26 : 07:33:01
|
| Hi Everybody,I am using Execute SQL Task and Data flow task to export result of a query to excel workbook. This workbook will be created based on today’s date. The query will return records for multiple Customer IDs. I need to create an SSIS package in such a way that, Excel file (workbook) name will be of today’s date. This excel work book should contain multiple sheets based on Customer IDs return by the query. And each these worksheet should contain data relted to that Cust ID only. For example if my query returns 1000 records which belongs to 5 customers, there will be one excel file generated having 5 sheets in it named with 5 Cust Ids, so that user can see related customer’s detail by clicking on particular sheet. In summary, a single excel file (workbook) should contain multiple worksheets created based on Cust IDs and it’s records. I am able to generate excel sheet based on today’s date containing all 5 Cust ID records in single work sheet. But not different work sheets.Could you please help me on this? Thanks in advanceVishal |
|
|
vishal.todkar
Starting Member
20 Posts |
Posted - 2010-06-02 : 03:03:54
|
| Can anyone help me on this ?Vishal |
 |
|
|
|
|
|
Need help-Generate multiple Excel sheets in 1 file