cannot find Microsoft.office.Interop to add to scr

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

cannot find Microsoft.office.Interop to add to scr

Author

Topic

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2009-12-09 : 04:29:52

Good day, I need help.

I cannot find Microsoft.office.Interop to add the reference.

I installed & register all the dll, copied to c:\program\..\primary interop assemblies.
followed the steps: C:\Program Files\Microsoft.NET\Primary Interop Assemblies\Readme.htm

And the dll exists & registered c:\WINDOWS\assembly

But when i go to the script task & add reference it's not there.

Please help.

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2009-12-09 : 05:24:08

Hi,

I got it going i had to copy the dll to

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

Regards

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2009-12-23 : 01:46:08

Good day,

I got the srcipt working on my Local PC.
But when importing on to server, i get the error.

"Could not load file or assembly 'Microsoft.Office.Interop.Excel, Version=10.0.4504.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified."

I copied the files & registered to all locations i have on my local PC.

But the the server does not have the Visual Studio .NET Command Prompt - not sure if it is needed as I use the register.bat

Regards

behrman
Yak Posting Veteran

76 Posts

Posted - 2009-12-24 : 09:39:34

Hi, ismailc.
Actually, if you want to use this DLL, following these steps:
1.On the Project menu, click Add Reference.
2.On the COM tab, locate Microsoft Excel Object Library, and then click Select. In Visual Studio 2005, locate Microsoft Excel 11.0 Object Library on the COM tab.
3.Click OK in the Add References dialog box to accept your selections. If you are prompted to generate wrappers for the libraries that you selected, click “Yes”.
Then you should be able to use this interop DLL, for more details, please visit Primary Interop Assemblies.
Hope this helps!
Thanks!

RAQ Report: Web-based Excel-like Java reporting tool

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources