Finally got it.I changed connection manager from sql authentication to windows authentication and gave the user admin roles.Did use any configurations now.Thanks all for the help.

Thanks,

Mahesh

For ssis configurations,I used sql server table where the password gets picked from table.

Right now it is encryptsensitivewithuserkey,I tries using donsavecasesensitive but when open the package with admin account then...

Hi,

I created proxy login for user and created job to run the package.

below is the error im gettng.

"Description: Failed to decrypt protected XML node "DTS:Password" with error 0x80070002...