Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
maihabib
Starting Member
22 Posts |
 Posted - 2014-02-02 : 06:55:10
|
| i have ssis package with protection level encryptallwith password.when i create the job and try to edit the command line and enter the password there /DECRYPT password/, it is not saved.i get the package from integration services server\msdband while importing the package i choose protection level: rely on server storageand also tried encrypt sensitive data with password.how can i make the job save my password.thanks, |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2014-02-03 : 08:51:01
|
The password IS saved but not shown.The next time you want to have a look/edit at the command line you have to reenter password information.If you don't look/edit at it then it will be there and the job will run.
Too old to Rock'n'Roll too young to die. |
 |
|
|
|
|
|
sql job doesn't save password