Install Excel on Server
-
Hello,
I was wondering if there are any drawbacks by installing MS EXCEL or MS office products on the sql server? Network guys seem hesitant to do so.
I was creating an Excel object in my Active X script but the server does not have Excel installed. Works fine on my work station but when I try to schedule package it fails. Thanks for your time.
-
Apart from any issues with the client application possibly hanging and causing a server restart (not much of an issue on your workstation, but a much larger problem when you ahve 100's of people connected) , macro virii in an Excel file, DLL's optimised for client workstations overwriting DLL's optimised for server workload, no particular drawbacks.
Why do you specifically need to create an Excel object?
--------------------
Colt 45 - the original point and click interface
-
What I did was create a DTS package. It has an Active X task that creates the Excel object and the fields it on success it goes to sql server task for the source and then to the Excel task for the destination, this exports the data to a designated common network drive folder, to provide some users with information every morning. So I thought, I would schedule the package to run daily. But without Excel installed, I have to schedule it on my PC. I hope this helps. Sorry, I should have went into detail to begin with. Thanks again
-
You have two options.
Option 1
If you absolutely have to have the information in Excel because of formatting or data placement requirements. What you do is create an empty Excel file on your workstation with all the required formatting, etc... then copy that to the server. Your ActiveXScript would then make a copy of this file each time you run the package. Have a look at this article about assigning a different filename to your connection http://www.sqldts.com/default.aspx?200
Option 2
If you don't need to worry about formatting, then just export the data to a tab-seperated text file. Give the text file an extension of XLS and Excel will open it without any problems.
--------------------
Colt 45 - the original point and click interface -
Thank you for your help and time.
Regards
Oscar
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply