Problem

When trying to open / run an SQL Server 2005 SSIS package from BIDS (Business Intelligence Development Studio) or Dtexec.exe tool, the following error can occur:

Error 1 Error loading PACKAGE_NAME.dtsx: Failed to decrypt protected XML node "PackagePassword" 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.

 

Solution

In order to solve this error can you change the ProtectionLevel property of the package from EncryptSensitiveWithUserKey to DontSaveSensitive.

 

It seems that this behavior occurs when you try to run the SSIS package by using a different computer or a different user account than the computer and user account that were used to create the SSIS package.

 

For more information regarding this error you can access this link:

http://support.microsoft.com/kb/904800

 


No feedback yet