Hi, I have faced this issue umpteen times. When I design package in SSIS designer it works very fine but the next time I log into designer I have to redo typing in the passwords for all the connection managers. Is there a work around? I use the default package protection level. Thanks...

The default protection level is EncryptSensitiveWithUserKey, so normally if you always log in with the same user account, you shouldn't have to retype the passwords. Try using the EncryptSensitiveWithPassword protection level. That way you only have to type 1 password when you open the package. You can keep this protection level when you deploy the packages or you can change it to ServerStorage.MCTS, MCITP - Please mark posts as answered where appropriate.

In addition to Koen description, you can read more about ProtectionLevel here: http://msdn.microsoft.com/en-us/library/ms141747.aspxhttp://www.rad.pasfu.com