Hi,

I am developing an SSIS based solution that utilizes logic in a custom .Net
assembly which is referenced from SSIS packages. Our current deployment
process for this assembly involves copying it to the following directories on
both of the nodes in the SQL Server cluster.

C:\Program Files\Microsoft SQL Server\90\DTS\Binn
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn

I would prefer to host it in the cluster's GAC which would have the
advantage of allowing side by side deployment of multiple versions of the
assembly.

Attempts to do so have however so far been unsuccessful. After using GACUTIL
on both nodes, the assembly did not appear in the GAC for the cluster.

Can anyone provide me with some tips?

Here is the version information for the SQL Server cluster.

Microsoft SQL Server 2005 - 9.00.3077.00 (X64) Dec 17 2008 20:40:08
Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on
Windows NT 5.2 (Build 3790: Service Pack 2)

Many thanks,

Scott