Steve,

As per your suggestion I apply the changes and it worked.

My scenario was as follows:

Transferred the tables from Oracle into SQL Server 2005 and save the SSIS Package at the end.

However I modified the package and add more components as business requirement, it fails to save the password on runtime, as a result package ended with failure.

However when I apply the changes and changed default setting to "EncryptSensitiveWithPassword",

it works fine and package ended with success.

Thanks for your input.

Syed