SFTP Task Error: Authentication was partially successful, but server requires additional authentication with: 'password,keyboard-interactive'. (Rebex.Networking)
If you are getting the subject error when using the File Transfer Task or the SFTP Task to transfer files and the transfer works successfully using a different tool, then check if you are using a semicolon (;) in your password. If so, this is what is causing the problem. The semicolon is used as a special character to delimit the individual parameters in the ConnectionString property. The work-around to solve this problem, if you cannot remove the semicolon from the password, is to perform the following steps:
- After configuring the connection manager, close the configuration dialog.
- Right-click on the connection manager and select "Properties".
- Type your password in the ServerPassword property.
- Close the Properties dialog.
Another possible reason for that error could be that you are using incorrect keys or a password. You should make sure that you are using the correct keys and password.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Error Message: Rebex FTP/SSL does not support SFTP/SSH protocol. Use Rebex SFTP or SSH component instead. (Rebex.Ftp)
Action While connectiong to an SFTP server, an error message from the FlleTransfer/Connection object is received. Error Message Rebex FTP/SSL does not support SFTP/SSH protocol. Use Rebex SFTP or SSH component instead. (Rebex.Ftp) Solution Use the ...How can I use a semicolon in a password?
If you are seeing an error message with the words “Authentication was partially successful” or “Authentication failed”, then check your password. If there is a semicolon (;) in it, that is the reason for the error. The semicolon (;) symbol is a ...How to dynamically modify the SSH authentication credentials at runtime using variables and expressions
Variables and expressions can be used to dynamically modify the authentication credentials used by the SSH connection manager at runtime. These are the credentials that are used to connect to an SFTP server using the File Transfer Task. The subject ...How to resolve File Transfer Task failing when no files exist.
This KB article is not relevant if you are using "Get Remote Files List" action on File Transfer Task. Instead, you can use this COZYROC prepared Javascript: https://www.cozyroc.com/ssis/script-ftp-file-exists-task If you are not sure there will be ...I recently upgraded to a new release of SSIS+ and noticed that the SFTP Task has been deprecated. Will my existing packages that use the SFTP Task still work with the new SSIS+ release?
The File Transfer Task replaced the SFTP Task starting with SSIS+ version 1.7. Packages that already exist and use the SFTP Task will continue to run without modification after you upgrade to SSIS+ version 1.7 or later. When you create new packages, ...