InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 00:33:48 GMT20http://www.sqlservercentral.com/Forums/Topic1277983-110-1.aspxThanks a million for this tip! I struggled with this for 2 days until I came upon this article. Works perfectly!Thu, 23 Aug 2012 10:12:37 GMTtrav1s_lanehttp://www.sqlservercentral.com/Forums/Topic1277983-110-1.aspxHello 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.RobFri, 13 Apr 2012 08:18:21 GMTrjdineenhttp://www.sqlservercentral.com/Forums/Topic1277983-110-1.aspxHi,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.Thu, 12 Apr 2012 11:02:08 GMTranjanivishhttp://www.sqlservercentral.com/Forums/Topic1277983-110-1.aspxGood afternoon everyoneI have a SSIS job that uploads file to FTP that works fine via SSIS.I have the protection level set to EncryptSensitiveWithPassWordI have deployed the package to sql server. when logged into Intergrated Services via SSMSwhen 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 RegardsRob Wed, 04 Apr 2012 06:43:20 GMTrjdineen