views:

469

answers:

1

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

+1  A: 

"The error you have posted is because you left the default setting for the ProtectionLevel property of your package set to EncryptSensitiveWithUserKey".

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

Randolph Potter