Adding Excel interop dll to SSIS VS2005
Add reference of Microsoft.Office.Interop.Excel.dll in Script Task,Visual Studio 2005. About Adding Excel interop dll to SSIS VS2005.
Learn Adding Excel interop dll to SSIS VS2005
To add reference of Microsoft.Office.Interop.Excel.dll in Script Task,Visual Studio 2005 does not provide a COM tab to browse and get the dll.
Workaround : Place the Interop dll in Microsoft .Net folder(Usually C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727), it will appear in the .Net tab in Add reference of Script Task. Also, register this dll using Regasm command. 12.0 version of this dll is compatible with VS2005.
Hi Shilpa,
Really thanks a lot. It helps me a lot for one of my requirement.
Regards,
Vidhya