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.

Answer 1

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

---

Arthur My Blog

Answer 2

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">

Answer 3

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.

Answer 4

You are welcome moh1kumr,

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

---

Arthur My Blog