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 |
|
anthu_soft
Starting Member
8 Posts |
 Posted - 2009-11-14 : 00:24:23
|
| Hi I have a package A. Inside Package A, I have used Execute Package task which is execute Package B in the same solution file.These files are in Machine A(Sql server2005). I need to move the solution file to machine B(Sql Server 2008). I moved the solution file and database to the Machane B. while opening the solution file in Machine B it automatically starts to upgrade but while upgrading it is asking password to decrypt. but In originally I am not setting any password in that Packages. I went on to the Machine A and checked the protection level. Package A has "Dont Save Sensitive",Package B has "EncryptSensitiveWithUserKey". I have changed the protection Level in Package B as "Dont Save Sensitve." Still the issue persist.Any solution most welcome..Thanks in AdvanceAnthuvan |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-14 : 09:18:04
|
| change protection level to allow server storage to control access |
 |
|
|
anthu_soft
Starting Member
8 Posts |
Posted - 2009-11-21 : 05:41:20
|
| Hi Russel,I couldn't change the protection level to server storage.any other way to migrate the packages without error?Thanks,Anthuvan |
|
|
|
|
|
|
Error while Migrating SSIS file