I created a package on my SQL Server (2012) through the import/export data wizard which exports data to another SQL Server (2008).
I set up a job which runs this package but I get an error:
Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state."
I found suggestions to set the Protection Level to "DontSaveSensitive", but after running it again on the job, I get this new error:
"Login failed for user 'username'.".
Note, running it on it's own / manually, it works fine. It is only failing on the job.
Any help is appreciated.