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 |
|
qman
Constraint Violating Yak Guru
442 Posts |
 Posted - 2010-12-09 : 13:12:22
|
| I have a parent package that calls numerous sub packages as individual steps. Each sub step uses a password to encrypt the package.My parent package keeps promting me to enter the password for the sub packages even though I am setting the password in the Execute Package Task editor.Any ideas? How can I pass the password so not to get promted? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-12-09 : 14:11:27
|
| i think you want to change protection level of package to use the option based on userkey and create it based on service account------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
qman
Constraint Violating Yak Guru
442 Posts |
Posted - 2010-12-09 : 14:15:20
|
| Change it for each sub package or the parent package?If it was changed to use a key, how would someone other than me edit the packages? The password was only enabled so that other users could edit the packages in my absence. |
|
|
|
|
|
|
Package calling package expects password