I've created an SSIS package but I'm unable to run it as a job from SQL Server Agent. Whenever I run the job, I receive a generic error message with no details. I created the package on my local system and saved it to the SQL Server. The package protection level I chose was "Rely on server storage and roles for access control". I set up the job through my account as a sysadmin. The package itself runs fine by itself, debugs properly, and I can run it on the server manually but not through the SQL Server Agent. The package basically selects data from 3 different servers, unions it, and exports the results as a CSV file on the server. Any help would be greatly appreciated.