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.