Error: "Please Specify Server password"
This error is probably related to your setting of the Package Protection Level for your package. Please see the Microsoft documentation here for information about what the different levels of package protection mean. This Microsoft documentation describes how to set or change the package protection level.
Even if you are not using a password because you are connecting to a regular FTP server, the connection manager considers the password property sensitive information. Keep that in mind when you read the documentation.
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
I get the error message "Please specify server password." even though I don't need a password to connect to the FTP server.
The problem probably has to do with your setting for Package Protection Level. Even though the error is different, please see this article for an explanation: Why do I get the following error when executing a package under a SQL Server Agent job: ...Error Message: Invalid Token Password
Action: Test Connection succeeds, but then the REST Connection Manager fails with the following error message. Error Message: Invalid Token Password Solution: Please check what your Package Protection Level is. If it is DontSaveSensitive, then all ...Error Message: Please specify server password.
Action: SSH Connection Manager is requiring a password, but the connection we are using is password-less. The connection only requires a SSH key. Error Message: Error message: Please specify server password. Solution: ...Error Message: You need to enter the Server Password
Action: When executing a package that includes Salesforce Source Component I get the following error message: Error Message: You need to enter the Server Password Solution: In the Package properties, there is a property called ...Error Message: SSH: Negotiation failed. The client and the server have no common encryption algorithm.
Action: When I use SSH Connection Manager to transfer files, I get the following error message. Error Message: SshSession(8)[1]:SSH: Negotiation failed. The client and the server have no common encryption algorithm. Solution: This error message ...