Unable to get assembly uploaded to server - Office 2010 Primary Interop

Question

Built C # Script component in SSIS, referencing Microsoft.Office.Interop.Excel Ver 14. Works fine on my laptop. Now I need to run it on Win 2008 R2 Server, and this 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 launched o2010pia.msi with a double click. He began to run and seemed to end abruptly, but without errors.

In readme, he showed what installed assemblies are installed, but none of them appear in the GAC. I ran this using an account that is part of the local Admin group. Not rebooted.

We are looking for an offer. - thanks

Answer 1

I have the same problem.

Looking at system requests in the download link above, we can see that Windows Server 2008 R2 is not mentioned ... And it may not be supported.

"System Requirements Supported Operating Systems: Windows 2000 Service Pack 4 (SP4), Windows Server 2003, Windows XP Service Pack 2 (SP2)

Microsoft Windows XP, Microsoft Windows Vista, Microsoft Windows Server 2003, Microsoft Windows Server 2008, Microsoft Windows 7

The following is also required: Microsoft.NET Framework 2.0 or later

Answer 2

I had the same problem and it was solved by running the command line as admin and doing:

msiexec /i o2010pia.msi

Answer 3

I had a similar problem on the x64 server for Windows 2008 R2, where the o2010pia.msi installer seems to go away during installation. I even tried to answer cnyborg by running the command line as admin and then running the msiexec / i o2010pia.msi command.

In any case, I deployed an ASP.NET web form application and while executing the following code:

 _Document wordDoc = wordApp.Documents.Add(ref templateFilePath, ref missing, ref missing, ref missing); 

I got an error:

Word could not read this document. It may be damaged. Try one or more of these: * Open and restore the file. * Open the file using the Text Recovery converter.

I tried downloading the .dot, .dotx, and .docx files, but received the same error message.

After repeated dragging and searching on Google, I found someone with a solution to a non-standard problem, but he solved my problem!

Here is the solution:

• Windows 2008 R2 x64 Server

  Create the directory C: \ Windows \ SysWOW64 \ config \ systemprofile \ Desktop.

• Windows 2008 R2 x86 Server

  Create the directory C: \ Windows \ System32 \ config \ systemprofile \ Desktop.

DONE!