I have a SSIS package that has a script component. In the script I reference a custom dll that contains some functions.
The dll is registerd with a strong name in the GAC on my machine and the SQL Server 2005 box.
The package works fine in Visual Studio. The problem lies when I deploy the package to the server. (note: several other packages created without the dll work fine on the server).
Is there something else that has to be configured on the server to be able to reference and use the custom dll
Thanks for your help.
Gurus: Please help! SSIS package using custom dll fails on server
DVdR
Are you using SSIS Logging to determine what the problem is It could be a dependent DLL that is not on the server such as Reporting Services (I ran into this one). We were using Local reports in a DLL and needed the VS DLL's to be registered on the server.
toc996
The problem is that it cant find the custom dll that I have created and installed in the GAC on the server.
I need to know if there is anything else I need to do to reference it.
Carl Karsten
Thanks for your responses.
I found that the problem was with the way I was viewing GAC; specifically this:
On your pc, use windows explorer to view the c$ on the server and navigate to the GAC - ie \\server\c$\windows\asssembly
What you see is not the server GAC but the one in YOUR pc. So it appeared that the custom dll was installed in the server GAC when it was'nt.
I used remote desktop and then used the explorer there to place the file in the GAC and all is well now.
itsmike