1
Vote

Unable to connect to SFTP server

description

Hi

I recently installed the ssis extensions and tried to connect to one of the sftp server and package is not connecting. It is failing with error message.

Here is the message i am getting

[Execute: ] Error: Error: Unable to List: Client not connected.
StackTrace: at Renci.SshNet.Session.SendMessage(Message message)
at Renci.SshNet.Session.SendDisconnect(DisconnectReason reasonCode, String message)
at Renci.SshNet.Session.WaitHandle(WaitHandle waitHandle)
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)

Thanks

comments

wcikanek wrote Aug 22, 2016 at 4:54 PM

I received a similar message today and found that it was caused by using a password parameter that has sensitive data = true. Not sure why this is not working.