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

This would suggest there has been a password change for a SQL Server login or a data encryption key has had a password change.

1.need to check trans.txt file is present 

2.proxy account use 

Test the connection to your FTP and see if the lo

You've encrypted a sensitive value as a particular user, and are now running it as another user on your server.

See this page.

Thanks for the resolution Patrick.

can u briefly tell what can i do to resolve this issue.

Thanks

Ranjan DS

Hi Ranjan,

To fix this issue, we can create a SQL Server Agent proxy account. This proxy account must use a credential that lets SQL Server Agent run the job as the account that created the package or as an account that has the required permissions. For more details about how to create SQL Server Agent proxy account, please refer to the following blog:
http://www.mssqltips.com/sqlservertip/2163/running-a-ssis-package-from-sql-server-agent-using-a-proxy-account/

For more information about how to resolve the issue, please refer to the methods in the KB:
https://support.microsoft.com/en-us/kb/918760

Thanks,
Katherine Xiong