I have a road block that I need to find a work around for. I work on a system where the Databases reside on a soley database server (SQL 2005).
I need to run a stored procedure on a nightly basis and export the results into a template excel file and put out on shares. Sounds simple right? Here's the problem. In order to do this through SSIS, I need to install Microsoft.Office.Interop.Excel on the server so I can reference the assembly in the SSIS package. Unfortunately, this is a huge company and trying to get this installed on the database server is not going to be allowed. So, does anyone have any idea on how to do this either w/o SSIS or w/SSIS working around this problem. Or, is this really a problem?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!