FTPS Connection and SFTP Task

[Paul Smith]

Hi All

I have created an FTPS Connection and am trying to use the SFTP Task to send a file to the Server.

The FTPS Connection says OK when I click test Connection but when the SFTP Task sends the file I get the following error

Error: 0xC002F304 at SFTP Task, SFTP Task: An error occurred with the following error message: "Rebex.Net.FtpException: The server has closed the connection. ---> Rebex.Net.TlsException: Secure connection was closed by the remote connection end.

   at Rebex.Net.WY.MD()

   at Rebex.Net.UJ.XB(TlsParameters A, TlsSession B, FtpTransferState C, Boolean D)

   at Rebex.Net.VJ.XB(TlsParameters A, TlsSession B, FtpTransferState C, Boolean D)

   at Rebex.Net.Ftp.KL(String A, Boolean B, UJ C, DH D, Int64 E, FtpTransferState H)

   --- End of inner exception stack trace ---

   at Rebex.Net.Ftp.KL(String A, Boolean B, UJ C, DH D, Int64 E, FtpTransferState H)

   at Rebex.Net.Ftp.FN(String A, String B, Stream C, Int64 D, Int64 E, DH H)

   at Rebex.Net.Ftp.PutFile(Stream sourceStream, String remotePath)

   at CozyRoc.SqlServer.SSIS.SftpTask._ExecuteSendStream(IFtpClient ftpClient, Stream stream)

   at CozyRoc.SqlServer.SSIS.SftpTask._ExecuteSend(IFtpClient ftpClient)

   at CozyRoc.SqlServer.SSIS.SftpTask._ExecuteAction(IFtpClient ftpClient)".

Task failed: SFTP Task

I have managed to transfer files using WinSCP from the same PC. so any assistance will be gratefully utilised

Regards

[caiti.mc...@gmail.com]

FTPS is not the same thing as SFTP. If you are connecting to an SFTP server that rejects SSL (which is the security that FTPS uses), your connection will fail. You need to use the SSH Connection Manager, which is the type of connection required for an SFTP server.