Agent Job failing with FTP task In SSIS package

  • Good afternoon everyone

    I have a SSIS job that uploads file to FTP that works fine via SSIS.

    I have the protection level set to EncryptSensitiveWithPassWord

    I have deployed the package to sql server. when logged into Intergrated Services via SSMS

    when i run the package, enter the password it works fine.

    But when i setup an agent job and then run that. The package itself runs. but it fails at the FTP task.

    what else can i check.

    Kind Regards

    Rob

  • Hi,

    This issue can be resolved by following these steps,

    Change the encryption of the SSIS package to "EncryptAllWithPassword" and change the package passoword by clicking "..." and provide a password and store this password in a document.

    Close the package and check if the package asks for the newly entered password while opening the package.

    Within the job step, when you try to edit the command line, it should prompt you for the package password. Once you enter the package password, it should add the following switch to the command line "/DECRYPT <password>", where <password> is your package password. The only issue here then is that the command line is not encrypted, but I satisfied for now to have the package working properly as a job.

    I was able to successfully execute my package, which includes an FTP upload, with no problems from the SQL Server Agent account by using this methodology.

  • Hello there.

    I after some digging about, i managed to get it working with exactly what you said.

    But thank you very much for replying.

    Take it easy.

    Thanks again.

    Rob

  • Thanks a million for this tip! I struggled with this for 2 days until I came upon this article. Works perfectly!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply