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,

Hello speedingwolf (AT) gmail (DOT) com,

If you are grabbing Excel through its object model then you will need it
on the server. You can though just install the dlls necessary. That said
MS do not support Office unattended and I know people who do use Office like
this and have jobs that run looking for the exe and kill it. it is notorious
for staying around afterwards.

Thanks Allan for your help.