ActiveX component can''t create object: ''excel.application''

  • I have taken over an existing project that has had several issues that need to be cleaned up. Recently a new issue started that has me scratching my head. It is a scheduled job that will not run one of the DTS packages. If I log on to the server, go into Enterprise Manager, and run the package manually it will execute without error. This started happening about a month ago and the only thing that has changed with this package is a reference to our new email host so that the report will get emailed once it has been completed. I have gone through and checked permissions and everything seems to be correct and excel is installed on the server.

    The really strange thing with this is that the test environment will run it without a problem. The production environment and test environment are all on the same server, not ideal I know but that is what the original developer had to do for other reasons. So under the SQL Server Group we have a server called "(local)" and then another called "<ourprojectname>\test". And when you look at the job properties the radio button is checked for "Target local server" in both prod and test. When we schedule the job to run in the test environment it completes without an error. How can this be happening?

    All of the code is the exact same between production and test, we have copied the entire package from test to production to be absolutely sure. We use an INI file to determine file locations and I have verified that the SA user has access to those as well. I even had the test environment access and save to the production folders as a test to be sure that it wasn't a permissions issue on the specific files and folders.

    What other setting could be different between the two that could be causing this?

    Here is the specific error: "Error Source= Microsoft VBScript runtime error. Error Description: ActiveX component can't create object: 'excel.application' Error on  Line 8. Error Source: Microsoft Data Transformation Services (DTS)Package Help file:sqldts80.hlp help context:4500 Error: -2147220482(800403FE)."

    Here is the line that it is complaining about:

    set app = CreateObject("Excel.Application")

     

    I have gone through a couple of suggestions that I found on this site as well as others while search through google but so far have not come up with a solution. If anyone has anymore insight I would greatly appreciate it! Thanks in advance!

  • What user account is the job under? This sounds like a permissions issue. Might need to log on with that user account and make sure excel isn't trying to processes and install change (dialog will get in the way and an error will be thrown but I don't recall if this was the same message).

  • Everything is being run under the SA user. The test environment uses the same user account as the production environment and its all on the same server. The SA user account is controlled by our IT Services Dept. so I do not have the login information for it but I did have one of the admins from IT log in as SA on the server and try opening excel to make sure nothing was prompting them and it was not. They tried running the job and it still gave them the error message. Then I had them run the job in the test environment and that completed without error.

  • OK I finally found the article I had come across before as I have seen this. Take a look here and should help

    http://support.microsoft.com/default.aspx?scid=kb;en-us;298725

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply