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.
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.