i am working on ssis 2008 so i have written vb.net script in my script task that given below errors .please give solution to resolve the problems

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » i am working on ssis 2008 so i have written...

i am working on ssis 2008 so i have written vb.net script in my script task that given below errors .please give solution to resolve the problems

Rate Topic

Display Mode

Topic Options

Author

Message

roshan.maharana

Posted Monday, December 03, 2012 2:08 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, January 07, 2013 11:54 PM
Points: 2, Visits: 12

Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Office.Interop.Excel, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.Office.Interop.Excel, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'
at ST_6397a822698f4948b5dd07bb1d0c3878.vbproj.ScriptMain.Main()

Post #1391808

Tom_Sacramento

Posted Tuesday, December 04, 2012 4:03 PM

SSCommitted

Group: General Forum Members
Last Login: Monday, May 06, 2013 6:38 AM
Points: 1,762, Visits: 462

Looks like the PIO's are not loaded - have you installed the Primary Interop Assemblies?

Tom in Sacramento

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Post #1392734

« Prev Topic | Next Topic »

Permissions