Hello Ashish,
The error you’re encountering may occur if the connection password is not being passed correctly at runtime, resulting in an empty credential being sent to the SFTP server.
Please review the following troubleshooting article, which explains the common causes and resolutions for this error:
Error - Login incorrect (530). The password was empty. ErrorCode: ERR_EMPTY_CREDS
In particular, check whether your SSIS package ProtectionLevel is set to DontSaveSensitive, as this can cause passwords and other sensitive values to be cleared when the package is saved or deployed. The article also covers alternative approaches, such as parameterizing credentials and supplying them securely at runtime.
If the issue persists after reviewing the article, please share:
- The exact error message from the execution log
- Whether the package runs in Visual Studio or only fails after deployment
- Your current package ProtectionLevel setting
We’ll be happy to investigate further.