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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Error While Migrating the SSIS file

Author  Topic 

anthu_soft
Starting Member

8 Posts

Posted - 2009-11-14 : 00:25:16
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 Advance
Anthuvan

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-11-14 : 09:35:55
No need to post multiple times.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=135817
Go to Top of Page
   

- Advertisement -