I get the following error when I execute my package as a SQL server agent job.
It is an SSIS 2008 package running on a SQL Server 2008 instance. My package security is DontSaveSensitive.
I don't even know how to begin fixing this error.
Where should I check first?
Date a value of time Log Job History (MyJob) Step ID 1 Server PCTSQL004 Job Name MyJob Step Name Job_1 Duration 00:00:00 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message Executed as user: CS\DmcSysManager. The process could not be created for step 1 of job 0x63BB5A86DB23F947866D2A806BE4CC6B (reason: A required privilege is not held by the client). The step failed.