Can't run SSIS package from sqlagent jobs
-
Hello,When I run package from integration it works,but I am trying to run SSIS package from sqlagent jobs and get this error:
-
use protection level as encryptallwithpassword and give password...it works for me...but i tried without any package configuration...hope this will work...
-
Save the package with password. Use EncryptAllwithPassword in package properties.
-
Hi Krasavita,
IN the properties change the Protection Level from "Encrypt Sensitive with User Key" to "Encrypt Sensitivity with Password" and enter a password in package password.
Now you can run this package using SQL agent.
You will be asked for the password while creating the job.
-
Hello,
This is still not working
-
Error:
-
I ran into this same issue earlier this week and found this article very helpful in solving my problem, http://www.proteanit.com/b/2008/02/13/ssis-ftp-task-code-to-set-the-password/
It is using a Script task to set the FTP password
Tim
-
Krasavita (10/3/2012)
Error:Krasavita, it will be nice if you let the error in the post, so others could use the post to solve a similar error. Were you able to solve your problem? If you did could you please share the solution? Thanks in advance.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply