DTS:Property" with error 0x8009000B

tolywang發表於2010-05-10

If you are using SQL authentication for the database connections in your SSIS package you may get the following error message when you schedule your SSIS package.

   Code: 0xC0016016

   Source:

   Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.

You can do the followings to fix the problem:

1.     1.       Change the Package Security ProtectionLevel from EncryptSensitiveWithUserKey to DontSaveSensitive

DTS:Property" with error 0x8009000B

2.       2.      Enable package configurations by right click on the package design surface and click "Package Configurations.."  to start Package Configuration Organizer.

DTS:Property" with error 0x8009000B

3.       Create configuration file using the Package Configuration Organizer.

DTS:Property" with error 0x8009000B

4.       4.     Modify the configuration file and store the password information of your connection string in the configuration file

DTS:Property" with error 0x8009000B

5.           5.      Run your package using the configuration file.

 

 

相關文章