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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2009-03-03 : 04:14:37
|
| Hi,I created a package with the protection level - "Encrypt all with password". I also created the deployment utility to deploy it in my dev box. On running this utility, choosing the option - "SQL Server deployment" and "Validate Package after Installation", the following steps, generated me an error after giving the valid password.Error: The package is encrypted with a password. The password was not specified, or it is incorrect.Though there is an error i could deploy the package in the SQL Server box. But Is there a way to change the password after deployment or at the time of deployment in order to keep the password confidential during the different different phase of deployment? (dev->test->Production)Please let me know if your not clear with my requirement. |
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2009-03-03 : 05:29:53
|
| I know the package protection level can be changed from the BIDS environment. Why i'm reiterating is because after creating the Manifest file, I would be handing over those deployments files (Manifest file, .dtsx and config file if any) to other teams to along with the "Password" which is setup and they should be able to change the password with out my knowledge when they deploy in Prod. Box.Is it the right way to do or should i give the entire project to them after development so that they can change the protection level accordingly and create deployment utility of their own.Your help is highly appreciated. |
 |
|
|
|
|
|
Deployment - Protection Level