Juarez PCE OTS 10.13.8.96
Server Name : MXOSV-OTSDB02
Job Name : TO_OTS
Job Status : Failed
DateTime : 20100601 10:43:50
Duration : 00:30:20
Message : The job failed. The Job was invoked by User MXOSV-OTSDB02\it.lhdba. The last step to run was step 2 (t). The job was requested to start at step 1 (YSD).
Step 1 (00:03:02) [Successful] : YSD
Executed as user: MXOSV-OTSDB02\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:43:50 AM Error: 2010-06-01 10:43:51.06 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: 2010-06-01 10:43:51.06 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: 2010-06-01 10:43:51.13 Code: 0xC0016016 Source: Description: Faile
Step 2 (00:27:18) [Failed] : t
Executed as user: MXOSV-OTSDB02\SYSTEM. ....0.2531.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:46:52 AM Error: 2010-06-01 10:46:52.80 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: 2010-06-01 10:46:52.82 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Property" 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: 2010-06-01 10:46:52.82 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Property" with error
-------------------------------------------------------
Set --->>> Persist Security Info:False
SSIS包括send mail功能 在VS2005中可以成功发送。
使用job调用ssis后，job失败mail不能发送errormessage与之前相同。什么password。。。不对，只好放弃mail功能使用 job 的通知调用smtp在job成功还是失败时发送简单的mail做通知。