So yesterday I had to 'adept' a package to lower the amount of times it shows as failing,this job runs every 15 minutes and we're moving it over to a new monitoring system,so I was asked to make it so that it would never fail the job if a specific failure condition occurred.
Now the job no longer shows this failure,but when I look into the log I see this for the step
Executed as user: .... Microsoft (R) SQL Server Execute Package Utility Version 9.00.5000.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 10:55:21 Error: 2015-05-27 10:55:21.37 Code: 0xC0016016 Source:
Description: Failed to decrypt protected XML node "DTS:Password" 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.
End Error DTExec: The package execution returned DTSER_SUCCESS (0). Started: 10:55:21 Finished: 10:57:35 Elapsed: 134.223 seconds.
The package executed successfully. The step succeeded.
I have tried everything on the article about this,nothing seems to work