sql server作业错误 [英] sql server job error

问题描述

你好朋友，



我的任务是每天晚上8点运行....每天运行良好，但昨天和今天的工作失败并发出此错误。



错误消息：



以用户身份执行：NT Service\SQLSERVERAGENT 。 Microsoft（R）SQL Server执行包实用程序版本11.0.2100.60（适用于32位版权所有（C）Microsoft Corporation）。版权所有。开始时间：10：18：57错误：2015-08-18 10：19：13.04代码：0xC0016016来源：DDDRetail导入SSIS描述：无法解密受保护的XML节点DTS：Property，错误0x8009000B密钥无法用于指定的状态。您可能无权访问此信息。出现加密错误时会发生此错误。验证是否有正确的密钥。结束错误错误：2015-08-18 10：24：46.52代码：0xC0029183源：从FTP FTP删除Trans文件任务描述：由/kde_0155/trans.txt表示的文件不存在。结束错误DTExec：程序包执行返回DTSER_FAILURE（1）。开始时间：10：18：57完成时间：10：24：47经过：350.612秒。包执行失败。步骤失败。







请帮我解决问题。







谢谢



Ranjan DS

Hello friends,

I have a task which runs at 8:00 pm every day....everyday it ran well, but yesterday and today the job failed and gave this error.

error Message:

Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 10:18:57 Error: 2015-08-18 10:19:13.04 Code: 0xC0016016 Source: DDDRetail Import SSIS 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: 2015-08-18 10:24:46.52 Code: 0xC0029183 Source: Remove Trans File from FTP FTP Task Description: File represented by "/kde_0155/trans.txt" does not exist. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:18:57 Finished: 10:24:47 Elapsed: 350.612 seconds. The package execution failed. The step failed.



Please help me out with the solution.



Thanks

Ranjan DS

推荐答案

我相信你的问题与包裹保护等级有关：



请查看这篇文章并告诉我它是否有帮助



https://support.microsoft.com/ en-us / kb / 918760 [ ^ ]



祝您好运^ _ ^

Andy

I believe your issue relates to the package protection level:

please review this article and let me know if it helped

https://support.microsoft.com/en-us/kb/918760[^]

best of luck ^_^
Andy

这篇关于sql server作业错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！