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.


Comments

Author: Vidhya15 Nov 2011 Member Level: Gold   Points : 0

Hi Shilpa,

Really thanks a lot. It helps me a lot for one of my requirement.

Regards,
Vidhya

Guest Author: Vitali20 Feb 2012

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!



  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: