Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sravanim
Yak Posting Veteran
58 Posts |
 Posted - 2014-04-25 : 03:42:11
|
| i got the below error message when a job was failed.Please let me know what is exact error causing for job failure.Executed as user: NORTHAMERICA\srvs9900. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 12:00:01 AM Error: 2014-04-23 00:00:01.45 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-04-23 00:00:01.48 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-04-23 00:00:01.89 Code: 0xC0202009 Source: MSPSGPSDataLoad Connection manager "ROADSDW" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Login failed for user 'NORTHAMERICA\srvs9900'.". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Cannot open database "ROADSDW" requested by the login. The login failed.". End Error Error: 2014-04-23 00:00:01.91 Code: 0xC0202009 Source: MSPSGPSDataLoad Connection manager "ROADSDW" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Login failed for user 'NORTHAMERICA\srvs9900'.". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Cannot open database "ROADSDW" requested by the login. The login failed.". End Error Error: 2014-04-23 00:00:01.93 Code: 0xC0202009 Source: MSPSGPSDataLoad Connection manager "ROADSDW" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Login failed for user 'NORTHAMERICA\srvs9900'.". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Cannot open database "ROADSDW" requested by the login. The login failed.". End Error Error: 2014-04-23 00:01:28.35 Code: 0xC002F210 Source: EXEC uspLoadMSPSGPSTable Execute SQL Task Description: Executing the query "EXEC [ETL].[uspLoadMSPSGPSTable] ?, ?" failed with the following error: "Error converting data type nvarchar to numeric.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:00:01 AM Finished: 12:01:36 AM Elapsed: 95.005 seconds. The package execution failed. The step failed. |
|
|
|
|
|
error message