13 January 2012

How to add reference in SSIS / DTSX

Put assembly in
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
OR
C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies
For accessing the dll, generate strong name for assemblies and put in GAC folder
C:\windows\assembly\
Open the Add Reference dialog box again and the assembly should be visibile.


Testato su SQL2005. Trovato qui.

UPDATE!
Sia in SQL2005, che in SQL2008R2 funziona solo se la DLL è messa in
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727