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)
 Microsoft.Office.Interop.Excel on Server

Author  Topic 

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2009-12-23 : 01:47:50
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
   

- Advertisement -