I have a script task that picks up an excel file and references Microsoft.office.interop.excel which is all fine. It runs fine on my workstation but when I deploy this to server it errors.
Script Task:Error: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).
I have checked that the proxy account has access to the excel location. I have also made sure the package is running in 32Bit mode on the server and in my debug environment, which, as I say works fine in debug but as soon as I deploy to server it fails. I have also checked to make sure that Microsoft.office.interop.excel exists in the GAC and is the same version.
I am at a loss as to what the problem here is.... Anyone got any ideas?
Thanks