May 4, 2010 at 6:12 am
Hi there
Fantastic that we can export to several sheets within excel. But can the sheets can have a name iso sheet 1, sheet 2, ... ?
If yes, how to do so ?
Kind regards
El Jefe
JV
May 4, 2010 at 11:49 pm
Hi,
There are basically two ways to achieve the same.
1. Use parameters
2. When creating the Excel sheet in the Destination Editor specify the name you wish
But I would always prefer using parameters for better flexibility.
Raunak J
May 5, 2010 at 12:52 am
hey, thanx for your quick answer.
This is through SSIS though. What about when users want to export using the standard reporting services ?
Kind regards
JV
May 5, 2010 at 1:04 am
This is interesting...SSIS yes possible SSRS never tried Excel export paging with respective names applied to sheets.
Please let me know if you come across any feasible solution.
Raunak J
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply