All geek questions in one place

Starting a SQL Server task with an error when starting in a scheduled task, but is executed when a task is executed manually

I have work on SQL Server 2005 with the ssis package.

Package as "EncryptSensitiveWithPassword" Security Level

the job has only one step of type Operating sytem (CmdExec), since ssis uses the excel output file and the server uses 64 bits

I pass the password in the command

runs as a proxy

The task runs fine when I right-click on "Start work in step ...", but when the task runs from the schedule, it does not work with an error:

... Code: 0xC0016016 Source: Description: Failed to decrypt secure XML node "DTS: Password" with error 0x80070002 "The system cannot find the specified file." You do not have permission to access this information. This error occurs when a cryptographic error occurs. Make sure you have the correct key. Error terminating ...

thanks for your input

+3
source share
1 answer

"The error you posted is that you left the default value for the ProtectionLevel property of your package set to EncryptSensitiveWithUserKey."

Source: http://www.sqlservercentral.com/Forums/Topic565927-147-1.aspx

To find a property, follow these steps:

  • VS
+3

Source: https://habr.com/ru/post/1715177/

More articles:


All Articles