Listing Directories whenusing Lsit, Send Or Receive on the SFTP Task

Jul 12, 2013 at 8:27 PM
Once I configure everything, I get this error once the connection is made:

[Execute: ] Error: Error: Unable to List: Server string is null or empty.
StackTrace: at Renci.SshNet.Session.Connect()
at Renci.SshNet.BaseClient.Connect()
at SSIS.Extensions.SFTP.SFTPConnection.ListFiles(String remotePath)

at SSIS.Extensions.SFTP.SFTPConnection.ThrowException(String Message, Exception ex)
at SSIS.Extensions.SFTP.SFTPConnection.ListFiles(String remotePath)
at SSIS.Extensions.SFTPTask.SFTPTask.Execute(Connections connections, VariableDispenser
variableDispenser, IDTSComponentEvents componentEvents, IDTSLogging log, Object transaction)

I can use FileZilla and have no trouble connecting, thou Filezilla asks if I want to use the unknow server certificate. Can you shed light into this...I really like this extension.
Feb 27, 2014 at 2:10 PM
Is host name in a parameter in your package? please try the sample project included in the downloads.
Sep 24, 2014 at 3:39 PM
i have the same issue, i´m doing a foreach to get a lot of file arround 5000 and sometimes the etls fails because this error, is anybody than can help you?


[Execute: ] Error: Error: Unable to Download: Server string is null or empty.
StackTrace: at Renci.SshNet.Session.Connect()
at Renci.SshNet.BaseClient.Connect()
at SSIS.Extensions.SFTP.SFTPConnection.DownloadFiles(List1 fileList)

at SSIS.Extensions.SFTP.SFTPConnection.ThrowException(String Message, Exception ex)
at SSIS.Extensions.SFTP.SFTPConnection.DownloadFiles(List
1 fileList)
at SSIS.Extensions.SFTPTask.SFTPTask.Execute(Connections connections, VariableDispenser variableDispenser, IDTSComponentEvents componentEvents, IDTSLogging log, Object transaction)