none
How to add an dll to GAC and reference the dll in SSIS Script task?

    Question

  • Hi ,

    I am working on a package which needs an external dll.I got the dll file but i don't know how to add an dll to Gac.

    I tried gacutil.exe to add an dll but it throws me an gacutil is not recognized as an external or internal command.When i researched on the issue i need to do it from visual studio command prompt tools.But i didn't find the the prompt in tools for visual studio 2008 tools.But i found the gacutil.exe file in C:\Program files(X86)\Microsoft SDKs\Windows\v7.0A\Bin folder.

    My question is how can i add the Dll to GAC and reference the Dll in SSIS.

    Any help is appreciated.

    Thursday, July 04, 2013 6:52 PM

Answers

  • Joost has written an excellent article about this:

    Referencing a custom assembly inside a Script Task


    MCSE SQL Server 2012 - Please mark posts as answered where appropriate.<br/> <a href="http://twitter.com/#!/Ko_Ver"><img border="0" height="80" src="http://www.twittericon.com/wp-content/uploads/2010/08/glossy-cute-blue1.png" title="Twitter Follow" width="80"></a><img border="0" height="100" src="http://blogs.lessthandot.com/media/users/koenverbeeck/ServerFan2012_small.png" title="SQL2012" width="100">

    Thursday, July 04, 2013 8:04 PM

All replies

  • You then can just drag and drop the dll in C:\Windows\assembly using Windows Explorer

    Arthur My Blog

    Thursday, July 04, 2013 7:44 PM
  • Joost has written an excellent article about this:

    Referencing a custom assembly inside a Script Task


    MCSE SQL Server 2012 - Please mark posts as answered where appropriate.<br/> <a href="http://twitter.com/#!/Ko_Ver"><img border="0" height="80" src="http://www.twittericon.com/wp-content/uploads/2010/08/glossy-cute-blue1.png" title="Twitter Follow" width="80"></a><img border="0" height="100" src="http://blogs.lessthandot.com/media/users/koenverbeeck/ServerFan2012_small.png" title="SQL2012" width="100">

    Thursday, July 04, 2013 8:04 PM
  • Thanks Arthur for the reply.I  followed your instructions but i am not able to find dll when i tried to reference in SSIS Script task.Could you please let me know how could i reference a dll in SSIS script task.


    Thursday, July 04, 2013 8:13 PM
  • You are welcome moh1kumr,

    Indeed as Koen mentioned it is as easy 1,2, 3:


    Arthur My Blog

    • Proposed as answer by V Karthik Monday, July 08, 2013 6:24 AM
    Friday, July 05, 2013 1:15 AM