Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Agent Job failing with FTP task In SSIS package Expand / Collapse
Author
Message
Posted Wednesday, April 4, 2012 6:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 6:22 AM
Points: 9, Visits: 41
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

Post #1277983
Posted Thursday, April 12, 2012 11:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 15, 2012 8:20 AM
Points: 1, Visits: 13
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.
Post #1282594
Posted Friday, April 13, 2012 8:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 6:22 AM
Points: 9, Visits: 41
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
Post #1283177
Posted Thursday, August 23, 2012 10:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 10, 2013 6:34 PM
Points: 1, Visits: 19
Thanks a million for this tip! I struggled with this for 2 days until I came upon this article. Works perfectly!
Post #1349241
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse