SQL Job Execution Issue in SQL-Server 2012

1
votes

I am Executing an SSIS Package in SQL-Server 2012 through SQL-Job. Individual package is getting execute in Visual-Studio and also after releasing it on Service-Catalog (Just for testing). But When I am adding same package without any source or any change, Its execution keep going without any error or end.

Later I got one error message during Job execution from Windows-Log Viewer and error message is as follow:

Error, [136] Job Daily Job 2 report: Process 4a94 was invoked by step 1, job 0x04B3B7D6263F2348B84183641 BF86091, but can not be terminated (Reason: Access is denied.)

I have applied settings as below.

enter image description here

what does this error mean and what solution I can apply`

I am creating the SQL-Job and Package Execution on Server directly.

1
ssissql-server-2012sql-job
Seems that the account running the job does not have enough permissions to access the package, you can either use a different account or grant permissions to the current one - Petaflop
@Petaflop: what permission I should assign? can you please elaborate ? - Irfan

1 Answers

0
votes

It seems that Account running SSIS job does not have enough permission to access source file/folder/package.

You need to give permission for user to access package from filesystem