ITPub博客

首页 > Linux操作系统 > Linux操作系统 > protected XML node "DTS:Password" with error 0x8009000B "

protected XML node "DTS:Password" with error 0x8009000B "

原创 Linux操作系统 作者:tolywang 时间:2010-06-02 10:55:21 0 删除 编辑

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

-------------------------------------------------------

 

SSIS 在VS2005中建立可以执行成功,使用job调用提示job失败。
 
ErrorMessage:
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: 2009-05-17 21:03:38.29     Code: 0xC0016016     Source:       Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B
 
解决:
在VS2005中做以下修改
Set --->>> Persist Security Info:False



SSIS包括send mail功能 在VS2005中可以成功发送。
使用job调用ssis后,job失败mail不能发送errormessage与之前相同。什么password。。。不对,只好放弃mail功能使用 job 的通知调用smtp在job成功还是失败时发送简单的mail做通知。 

 

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/35489/viewspace-664217/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: startup force
请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    14695370