February 1, 2012 at 10:44 am
Yes, I've found several posts regarding exporting data to Excel format. I'm not getting the results I'm expecting, though, and the posts I've found have not been helpful in my specific instance.
The direction I've decided to go is an SSIS export package to Excel. When I create the package and run it the first time from within Visual Studio, it works almost fine. A new tab is created in the destination file and it even has data. (The annoyance that I have is that when I open the destination file, the newly created tab that contains my data is grouped with an existing tab and it is the existing tab that is active. You must click an inactive tab to ungroup the tabs, then click on the tab that contains the data. I see this has being very confusing for my end-users).
Aside from this annoyance, the process does work. However, if I run it again, the process fails since the tab already exists in the destination file. Is there is way to overwrite the existing tab during subsequent runs, or automatically delete it prior to the export? One of the posts that refered to this issue suggested that I create an Excel Template. However, a template extension could not be used in the Import/Export Wizard. Anyone have any suggestions on this one?
The second issue is that when I create a Agent Job with the SSIS Package, the job run successfully, but there is no data. A new tab IS created; and the columns headers are in the new tab, but there is no data. Can anyone explain this and sugguest a solution?
Randy
February 1, 2012 at 12:38 pm
Have you considered using SSRS instead? You can control the pagination, tabs and tab labels quite handily, and schedule the delivery to your users.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply