Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL server agent SSIS error Expand / Collapse
Author
Message
Posted Wednesday, June 19, 2013 6:39 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 15, 2013 4:32 PM
Points: 63, Visits: 116
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.
Post #1465435
Posted Thursday, June 20, 2013 3:49 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:38 AM
Points: 2,224, Visits: 2,658
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?).


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1465552
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse