I am developing a Script Task for my SSIS package to transfer a file via FTP over SSH (SFTP). I have a nice set of Assemblies/DLLs (purchased from IP*Works) that gives me the added functionality of SSH. To even get Visual Studio for Applications to see it in the reference list, I copied the DLL (nsoftware.IPWorksSSH.Sftp.dll) to the C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 directory, added it in the references for the script, and added the Imports nsoftware.IPWorksSSH.Sftp line in the script. As described in: http://sqljunkies.com/WebLog/knight_reign/archive/2005/07/07/16018.aspx Yet, when I try to run the SSIS package I get a DTS Script Task Runtime Error: Could not load file or assembly 'nsoftware.IPWorksSSH.Sftp, Version=7.1.2203.0, Culture=neutral, PublicKeyToken=cdc168f89cffe9cf' or one of its dependencies. The system cannot find the file specified. I tried to move the DLL to the bin directory in the SSIS Package, but that did not help. Any Ideas? Thank you for your time, -Tim

You need to add the DLLsto the GAC as well! Kirk'spost describes howto use the DLLs at designtime. To use them at runtime they need to be in the GAC. -Jamie

Thank you, As a database person I was not aware of the GAC. I will use the following statement: gacutil /i nsoftware.IPWorksSSH.Sftp.dll to add the DLL to the GAC. As I amcreating the SSIS Packages on development stations, I assume I will also have to add the DLL to the SQL Server GAC. I wouldn't assume that the SSIS Package Deployment Utility is intelligent enough to do that. Thank you! -Tim

You will have to add the DLLs into the GAC of the machine where the packages are running - in other words, probably where you have installed SSIS. SQL Server is irrelevant. You are right that this is a step you have to do outside of the deployment utility. A bit more info here: http://blogs.conchango.com/jamiethomson/archive/2005/11/02/2341.aspx -Jamie

Hi Tim Just to let you know there is no such thing as SQL Server GAC. Regards Steve

Thank you all for your help... One more question: There is a gacutil.exe in the Microsoft.Net\Framework\v1.1.4322 folder but not the v2 folder. Is there a new utility for .Net 2? Also there is a gacutil.exe in the Visual Studio SDK\v2.0\Bin directory. Is that to be used for .Net 2? Also, I didn't mean to say the SQL Server GAC, but the GAC on the machine running SQL Server. Sorry about the confusion. Eric, I think it is fantastic the /n Software is going to be releasing a suite of SSIStasks. It will definatly keep us asloyal customers. Thank you all for your help, -Tim

Tim, As far as I am aware you use the gacutil.exe in VS SDK directory, yes. -Jamie

Yes, you can. I've used gacutil.exe that way a few times successfully. Dan http://lawncare.fortunecity.com/

Hi, Would you please tell me is there any free library for SFTP? I has downlaoded nsoftware trial version but in that version i didn't get nsoftware.IPWorksSSH.Sftp.dll... Would you please send me that dll on my mail or you can give me link from where i can download it thanks Manish jain

Hi, Would you please tell me is there any free library for SFTP? I has downlaoded nsoftware trial version but in that version i didn't get nsoftware.IPWorksSSH.Sftp.dll... Would you please send me that dll on my mail or you can give me link from where i can download it thanks Manish jain It is hard to find a good and free lib. If you are willing to pay some money, commercial library like the Ultimate SFTP will help.