SSIS and Microsoft Excel
Microsoft Excel, Microsoft.Office.Interop.Excel, SQL Server 2005, SQL Server 2005 import/export, SQL Server 2005 interoperability, SQL Server Integration Services, SSIS
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?
Thanks!
Software/Hardware used:
Software/Hardware used:
ASKED:
February 21, 2009 4:43 AM
UPDATED:
February 24, 2009 10:58 AM
RELATED QUESTIONS
- What permissions are necessary to allow an SSIS script to read an excel file in a SharePoint Library?
- PicklistStrings returning a blank view when on a local replica
- Trying to Design a Split Database Access 2007/SQL Server Express
- SQL Server Express 2008 w/Tools vs. Advanced
- VBA Copy and Paste using dates
Answer Wiki:
I haven't extracted data using SSIS before, but it is easy enough to use Excel and VBA as the controlling program, and pull the data from the database, and then save it to where ever you need. You can then schedule the excel workbook to open and run every night.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
