Key not valid for use in specified state using SSIS tasks

The error code 0x8009000B is raised by SSIS when a package tries to access sensitive information that has been encrypted but cannot be decrypted in the current execution context.

This SSIS error occurs when a package attempts to access encrypted sensitive properties, such as passwords, without the required decryption key or password.

All nsoftware SSIS task password fields are marked as sensitive, meaning SSIS encrypts them when the package is saved. If the package is deployed or executed without proper decryption settings, this error can occur.

To resolve this, you must configure the package protection level appropriately. One common approach is to set the SSIS package ProtectionLevel to EncryptSensitiveWithPassword and assign a PackagePassword. This ensures sensitive values can be decrypted at runtime.

When executing the package (for example via SQL Server Agent or command line), the same password must be supplied using the /DECRYPT option. Alternatively, if DontSaveSensitive is used, values must be explicitly provided using the /SET property option.

Additional deployment approaches and details are documented in Microsoft KB article http://support.microsoft.com/kb/918760.