9
Built a C# Script Component in SSIS referencing Microsoft.Office.Interop.Excel Ver 14. Works fine on my laptop. Now I need to run it on a Win 2008 R2 Server and that assembly does not exist.
I downloaded PIARedist.exe Version:14.0.4763.1024 from: http://www.microsoft.com/download/en/details.aspx?id=3508
After extracting I ran the o2010pia.msi by double clicking. It started to run and appeared to end abruptly but without errors.
In the readme it showed what the installed assemblies would be but none of them show in the GAC. I ran this using an account that is part of the local Admin group. Didn't reboot.
Looking for a suggestion. - thanks