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 |
|
Cathryn
Starting Member
4 Posts |
 Posted - 2009-02-20 : 23:39:01
|
| 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! |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-02-23 : 12:23:16
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926 |
 |
|
|
|
|
|
SSIS export to Excel w/o Interop.Excel assembly?