October 8, 2014 at 3:44 pm
I am getting message from SQL Server Agent Job when i tried to submit the job. SSIS package is working fine from BIDS.
Executed as user: FWWTR\SqlAdmin. ...n 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:15:01 AM Error: 2014-10-07 01:15:01.41 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 Error: 2014-10-07 01:15:01.85 Code: 0xC0016016 Source: 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 that the correct key is available. End Error Error: 2014-10-07 01:15:01.85 Code: 0xC0016016 Source: Description: Failed ... The package execution fa... The step failed.
I looked at the following document on Microsoft site , it didn't work , still job is failing.
FYI, Job was working fine till Monday night, it's failing since past two days.
Any help apperciate.
Thank you
October 9, 2014 at 1:17 am
What is the protection level of the package?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 9, 2014 at 8:45 am
EncryptSensitiveWithUserKey
October 9, 2014 at 1:01 pm
kshatriya24 (10/9/2014)
EncryptSensitiveWithUserKey
Either change it to DontSaveSensitive and store user names and passwords in configurations, or change it to SavenSensitiveWithPassword and supply the password to SQL Server Agent.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 9, 2014 at 1:25 pm
Thank you.
Tried changing protection level of package with SavenSensitiveWithPassword and supply the password same as SQL Server Agent.
Runs fine in BDIS or when i execute package. It fails in SSIS job.
I check author and SQL agent run under same owner.
Same error.
Message
...n 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:20:12 PM Error: 2014-10-09 14:20:12.78 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 Error: 2014-10-09 14:20:13.19 Code: 0xC0016016 Source: 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 that the correct key is available. End Error Error: 2014-10-09 14:20:13.19 Code: 0xC0016016 Source: Description: Failed ... The package execution fa... The step failed
October 9, 2014 at 2:15 pm
First, save the SSIS Package using Rely On Server For Security (or however it is worded). Then try the job. That will show you whether the issue is really with the password or somewhere else. If it runs, then you know the issue is with the password being supplied.
If it is with the password, you just need to figure out the correct password to use. Did you supply a password when you saved it?
-SQLBill
October 14, 2014 at 8:59 am
Thank you . it worked.
I had to re-generate the connection within the package for Iseries ODBC. I deleted the old connection and created again , it worked.
Apperciate your help.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply