Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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 Expand / Collapse
Author
Message
Posted Monday, December 3, 2012 2:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 25, 2014 3:38 AM
Points: 3, Visits: 57
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
Posted Tuesday, December 4, 2012 4:03 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 19, 2014 8:15 PM
Points: 2,275, Visits: 589
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 »

Add to briefcase

Permissions Expand / Collapse