SFTP forech download 5000 files issue

Sep 24, 2014 at 3:41 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(List1 fileList)
at SSIS.Extensions.SFTPTask.SFTPTask.Execute(Connections connections, VariableDispenser variableDispenser, IDTSComponentEvents componentEvents, IDTSLogging log, Object transaction)