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.
Really thanks a lot. It helps me a lot for one of my requirement.
Hey Noel, It was great to meet you at the event! That was a great write up of the pre-con as well as the day itself. Eating lunch on the lawn was a very nice experience; hope to see you in FL again!