I created an SSIS package on my IS Server logged in as Server/Administrator.
I have a proxy account set up with Server/Administrator credentials that is used to run the package. Server/Administrator account has sysadmin rights on the Database and is what the job is run under. I am able to run the package fine either directly from BIDS, or right-clicking the job and selecting "Start Job..." from SSMS. But if I schedule it, it gives me the following error -
Failed to decrypt protected XML node "DTS:Property" 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.
which seems to me as an access issue.
I have tried 2 approaches to scehdule this package to run every night as a job.
1. Upload package on IS and schedule that.
2. Run package from the filesystem.
Both don't work when scheduled, but run fine when i righ-click and run directly.
What am I missing here?