Click here to Skip to main content
15,794,593 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
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
Posted
Comments
Sergey Alexandrovich Kryukov 18-Aug-15 11:09am    
Excuse me, what's the use of showing some exception stack without showing the code throwing the exception?
—SA

1 solution

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
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900