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.


Anonymous said...

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

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.