Referencing external .NET assemblies

Question

Does referencing external .NET assemblies in script components or script tasks require the assemblies to be on the GAC? Or is there some way to provide a discovery path?

---

Paulo Morgado

Answer 1

Yes, assemblies should be in GAC. Please check this link: http://beyondrelational.com/blogs/niteshrai/archive/2010/04/13/referencing-an-assembly-inside-ssis-script-task.aspx

---

Nitesh Rai- Please mark the post as answered if it answers your question

Answer 2

Yes they need to be in the GAC. Also be aware of another nuance around this: http://consultingblogs.emc.com/jamiethomson/archive/2005/11/02/SSIS_3A00_-VSA-requires-DLLs-to-be-in-the-Microsoft.Net-folder-_2800_but-not-all-the-time_2900_.aspx

---

http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Answer 3

As far as I could test at development time, the assembly doesn't need to be on the GAC but it needs to be on Binn folder of SQL Server DTS (C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn, in my case).

I am signing the assembly, nevertheless, in order for the script tasks to have the right reference, and referencing the assembly copied to the Binn folder.

---

Paulo Morgado