A package has been created and I have scheduled it, when it runs it errors. The description to the error is"Executed as user: GMFS\sql_service_account. The package execution failed. The step failed." which is not very helpful. I can run the dtx package successfully.
The Protection Level is set to ‘EncryptSensitivewithPassword’
I have compared this with other packages that have been scheduled before and i can't see any differences.
Has anybody got any ideas?