SQL Server Jobs with SSIS packages – Failed to decrypt protected XML node “DTS:Password” with error 0x8009000B

In addition to what Kiran’s answer suggests, make sure this is set correctly:

There is an option to in SSIS to save passwords(to access DB or anyother stuff), the default setting is “EncryptSensitiveWithUserKey”… You need to change this.

Package Proprties Window >
ProtectionLevel — Change that to EncryptSensitiveWithPassword
PackagePassword — enter password-> somepassword

Leave a Comment

tech