Hi,
In our project we have two SSIS package.
And there is a task (Execute SSIS package) in First package that calls the execution of second package.
I m continuously receiving an error "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."
As we are running first package by job, job runs successfully logging above error
The protection level of second package is set to "EncryptSensitiveWithUserKey"
Can anybody please suggest how to handle it?
If these DTSX has been saved on the MSDB you could use 'Server Storage' as protection level.
EncryptSensitive.. is the default protection level for the packages.
|||If protection level property of the package has EncryptSensitive WithUSerKey means that only the author of the package is allowed to run it. This KB offers diffrent alternatives to solve your issue:
An SSIS package does not run when you call the SSIS package from a SQL Server Agent job step:
http://support.microsoft.com/kb/918760
|||Admin,
This topic is a good candidate for a "sticky" for the forum.
This question is asked once a day... we could come up with a synopsis on package encryption
|||The DTSX is not saved in the MSDB,
its at disk only.
No comments:
Post a Comment