File download from SFTP

SSIS PowerPack FTP / SFTP
1

Hi All,

I am facing issue while connecting to FTP using ZappySys - ZS Secure FTP task. My SSIS package is giving below error - tried changing solution level and package level - protection level too.

– Error- An error occurred with the following error message: "Login incorrect (530). Password was empty. ErrorCode: ERR_EMPTY_CREDS
Login incorrect (530). Password was empty.

image
image550×560 14.5 KB

2

Does the package works fine when you run in VS, but fails when running in a job? Are you using parameters?

3

File download from SFTP involves securely transferring a file from a remote server to a local system using the Secure File Transfer Protocol. Users authenticate with credentials or keys, connect to the server, select the required file, and download it.

4

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.