question

artistlover avatar image
artistlover asked

job failing on ssis call

i have a job with 7 steps that has never failed. two days ago it failed calling ssis package with following error Date 11/5/2013 8:31:28 PM Log Job History (DENALI-Parts-Denali-Parts-3) Step ID 4 Server DENALI Job Name DENALI-Parts-Denali-Parts-3 Step Name Execute SSIS Package Duration 00:02:50 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message Executed as user: mem1\RMR0. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:31:39 PM Could not load package "\MoveData" because of error 0xC0014062. Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Unable to complete login process due to delay in opening server connection). The SQL statement that was issued has failed. Source: Started: 8:31:39 PM Finished: 8:34:18 PM Elapsed: 159.438 seconds. The package could not be loaded. The step failed. I looked at it and everythng looked fine. Last night i get the following failure. Date 11/6/2013 8:29:56 PM Log Job History (DENALI-Parts-Denali-Parts-3) Step ID 4 Server DENALI Job Name DENALI-Parts-Denali-Parts-3 Step Name Execute SSIS Package Duration 00:01:03 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message Executed as user: mem1\RMR0. ...ver Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:29:57 PM Error: 2013-11-06 20:30:09.64 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "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: 2013-11-06 20:30:17.23 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "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: 2013-11-06 20:30:57.23 Code: 0xC0024102 Source: Transfer SQL Server Objects Task De. The step failed. It runs when running from that step. The only thing that changed on server was trying to get rid of old users. this is identical to another job except for the particular database is different name. Please help this makes no sense. both are using ssis sql is with proxy that is the same they are using a move data that goes from one server to another and both of those are the same.
ssis
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
bi2013 avatar image
bi2013 answered
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

no no upgrades that is the first thing i asked.
0 Likes 0 ·
The thing is no one has touched the package why would a password be saved much less changed in reference to the second part.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.