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 script in my script task that given below errors .please give solution to resolve the problems Expand / Collapse
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: Tuesday, August 4, 2015 7:17 AM
Points: 3, Visits: 65
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=, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.Office.Interop.Excel, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c'
at ST_6397a822698f4948b5dd07bb1d0c3878.vbproj.ScriptMain.Main()
Post #1391808
Posted Tuesday, December 4, 2012 4:03 PM



Group: General Forum Members
Last Login: Monday, November 23, 2015 7:33 AM
Points: 2,726, Visits: 752
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...
Post #1392734
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse