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 special symbol used as a delimiter character in the ConnectionString property. If you specify the password in the Connection Manager, the semicolon will not be included as part of the password and all characters after the semicolon will be lost .
Fortunately, COZYROC has a workaround. After you configure and close the Connection Manager dialog, right-click on the Connection Manager and select "Properties". Enter your password into the ServerPassword property. This will preserve your password and should work with any Connection Manager.
Book a Presales Call
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
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 ...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 ...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, ...Error Message: Negotiation failed. Requested service is not implemented.
Action: Packages that used to work fine have suddenly started failing. These packages use the SFTP task. Error Message: Negotiation failed. Requested service is not implemented. Solution: Security algorithms are improved and changed regularly. It ...Can I use Modern Authentication with the Dynamics CRM Adapters?
COZYROC Dynamics CRM Components do not support Modern Authentication. Our Dynamics CRM components use Microsoft Dynamics CRM WCF API, which is not compatible with Modern Authentication. If you prefer to use Modern Authentication to connect to ...