SQL 2005 SSIS package won't run within a Stored Procedure
Posted on 2006-06-29
SQL 2005 EE 64 Bit
Win 2003 EE 64 Bit
I have a SSIS package that was migrated from a DTS package. When I right click on the package & click run package, the package runs with no problems. When I try running the package from a SP, it gives me the following error:
Error: 2006-06-29 07:37:50.33
Description: 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 t
hat the correct key is available.
SSIS service is configured to run under a sysadmin account. The account I am trying to run the SP is a sysadmin as well.
I found a KBB article that mentioned modifying the protectionproperty level. I have tried different protectionpropertylevels to see if that would make a difference & it didn't.
Anyone have any ideas what might be happening? I have tried recreating this package & received the same error.