I have a job on SQL Server 2005 running a ssis package.
The package as the protection level 'EncryptSensitiveWithPassword'
the job has only one step of type Operating sytem(CmdExec), since the ssis uses an excel output file and the server is 64bits
I do pass the password in the command
run as a server proxy
The job runs fine when I right click on 'Start job at step...' but when the job runs from the schedule it fails with error :
... Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x80070002 "The system cannot find the file specified.". 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 ...
thanks for your input