CODEWITHSUNDEEP
excelssis
nickfinity
nickfinity

Reputation: 1119

Run Excel Macro as part of SSIS task

I've never done much heavy lifting with SSIS, only very simple stuff, so I hope you'll excuse my ignorance. I have a fairly simple package that pulls data from Excel into SQL Server. It works fine. My problem is that there is a macro in the Excel file that updates the data from, I believe, a web service. That's code I can't seem to access. My question then is this, can I use a script task to open the Excel file, run the macro, save it, and then import the data?

Ok, so before I posted the above question I went ahead and created a script task that should open the spreadsheet and run the macro. However, when I run it I get errors, the first being:

System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Office.Interop.Excel.Version=14.0.0.0.0

Should I attack the problem a different way? Any suggestions? I sincerely appreciate any help.

Thanks,

Nick

Upvotes: 2

Views: 2754

Answers (1)

rvphx
rvphx

Reputation: 2402

Download and install The primary interop assemblies on the machine where you are running the package. I am not sure if the License agreement allows you to install the Assembly on a server. This should resolve your issue hopefully.

Upvotes: 1

Related Questions