SFTP Banner

Jul 19, 2013 at 10:33 PM
I'm having issues getting a SFTP task to work. I have all the variables entered based on the sample package, but I keep getting the following error:

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

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

Now I logged into the FTP server i'm trying to upload to, to verify access and I noticed it has a banner that pops up in winSCP. Is that something that could be causing issues with the SFTP task upload?
Feb 27, 2014 at 2:09 PM
Is the Host name a Variable in your package? See the sample project in the downloads sections.