How to add the Microsoft Office Interop in ssis c# script task

Question

In SSIS script task ,I was trying to add the reference, Microsoft Office Interop Excel.Is it a service reference? It is not in the list of referenes

Answer 1

Go to Add Reference... in VS while editing the script, like you normally would. Click the Browse button. Look for the Microsoft.Office.Interop.Excel.dll in the following directory (or at least, something like it).

C:\Windows\assembly\GAC_MSIL\Microsoft.Office.Interop.Excel\15.0.0.0__71e9bce111e9429c

This worked for me on my machine, and I am running Windows 10. I have no idea if this will be different on another machine. I have Excel installed, so you may need that as well.