was连接oracle+rac,SQL Server 2008连接Oracle 11G RAC执行Package报错

Juarez PCE OTS 10.13.8.96

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) 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

[8D2u'z$UD xb0

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

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 ---&gt>> Persist Security Info:False

                             12476590_200905181329571.jpg

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

这次在做Oracle 11G RAC升级上线时,又遇到类似错误,此次问题解决如下:

Data Source=WSJ_DELLL10;User ID=username;password=*********;Persist Security Info=True; unicode=true;

去掉了unicode=true;

即: 修改SQL Server连接11G RAC的连接字符串,去掉unicode=true选项。。。

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值