Thursday, August 2, 2007

Referencing a Custom .NET DLL from within a SQL Server 2005 SSIS script task

It is not difficult to reference a custom .NET DLL from within an SSIS script, but there are a couple of things that you will need to do:

  1. Sign your DLL
  2. Put it in the GAC (copy it to c:\windows\assembly)
  3. Put a second copy in the C:\Windows\Microsoft.NET\Framework\v2.0.xxxx folder

Once you have done all of these things, then it will show up in the list of available libraries when you attempt to add a reference to your script task.  I found this out the hard way, so hopefully this will help at least one other person.

More details are available here.

2 comments:

Anonymous said...

Yep, that helped at least two persons here in Paris. ;)
Thanks!

Rolf said...

Thank you this worked me so that i was able to use DotNetZip dll files in my SSIS projekt. Thus beeing able to uncompress zip files from a FTP.