MS Office, Excel on SQL2000

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Greetings,

I'm new to DTS and have a question. I'm creating a DTS package that has
ActiveX script to create/open an excel application on a share. However,
when I excecute it gives me a package error:

Error Description: Error Code:0
Error Source=Microsoft VBScript runtime error
Error Description: ActiveX component can't create object:
"Excel.Application'

I've seen one post regarding to this on google and the solution is to
install Excel. I have a test server and install Excel and it works
fine.

The question is: "What issues if I installed Excel on the production
SQL?" In addition, is there any other way around installing Excel?

Thanks,

.

Relevant Pages

  • Re: Create multiple AD users
    ... I don't install Excel on DC's either, ... Excel installed. ... It reads from a comma ... Microsoft MVP Scripting and ADSI ...
    (microsoft.public.windows.server.scripting)
  • Re: Excel CreateObject on server
    ... Is there any reason NOT to install EXCEL on an application server (Windows 2000 or Windows 2003) to accomplish this. ... Do we need to install a full copy of Excel or is there a more limited approach to install just enough to allow programmatic manipulation. ...
    (microsoft.public.excel.programming)
  • Re: Excel is not working (DATA1PRO.msi Error 1076 ) resolution for me
    ... really a gr8 help, had lot of documents to be filled and excel got corrupted. ... Close Excel first and On the Windows Taskbar ... starts trying to install excel!!! ... the error message says "the feature you are trying to use is on a network ...
    (microsoft.public.excel.setup)
  • the reference microsoft.visualstudio.tools.applications.runtime.dl
    ... I am trying to use the class ServerDocument, to be able to insert or update ... data in a excel workbook/sheet without having to install excel on the server. ... I can create a Excel project in my development environment, ...
    (microsoft.public.vsnet.vstools.office)
  • Re: Reference an Excel library that you dont have?
    ... > reference to Excel 2000 without actually having Excel 2000 installed on ... >> dim appExcel as Excel.Application ... >>> In the project is a reference my own existing Excel 10 library. ... >>> don't have this or is it really neccessary to install Excel 9? ...
    (microsoft.public.vb.general.discussion)