Hello,
We currently have a package that is associated with a SQL Agent job. The job is failing with the follwoing error "The package could not be loaded".
This error doesn't occur all the time, it is happening most of the time. The job usually doesn't fail when I go into SSMS and run the job using the interface.
I have checked that the account that the Agent uses has the proper database roles in the msdb database. I have checked to make sure that the Agent account has the appropriate network access as well. I have also checked that the ProtectionLevel is set correctly.
If anyone could please point me in the proper direction to prevent this error and if there is anything that I should be looking at in the environment which could be causing this error.