I have an SSIS package that populates an Excel file. The package is run from a SQL Server Agent job.
It all runs fine, but now I have added a Macro to the Excel file. This macro causes the Package to fail when it is run.
Are there any permissions I need to add to allow the SQL Agent account to run the macro?
This is the error:
Description: 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.
After installing Excel, the error is as follows:
The file name or path does not exist. • The file is being used by
another program. • The workbook you are trying to save has the same
name as a currently open workbook. at
Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object
UpdateLinks, Object ReadOnly, Object Format, Object Password, Object
WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin,
Object Delimiter, Object Editable, Object Notify, Object Converter,
Object AddToMru, Object Local, Object CorruptLoad)
Best Answer
Solution:
https://stackoverflow.com/questions/881132/retrieving-the-com-class-factory-for-component-failed