June 19, 2013 at 6:39 pm
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.
June 20, 2013 at 3:49 am
etl.laptop (6/19/2013)
(reason: A required privilege is not held by the client).
This indicates an issue with permissions. Are you able to execute the package manually? Check all permissions of the service-account of the SQL Agent (i.e. CS\DmcSysManager?).
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply