SSIS Error : Non-SysAdmins have been denied permission

Question

I am running this SSIS Package but I am getting this error

Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account.  The step failed.

There are many other packages that are working fine but this one I get an error

I wonder if anyone have faced this error and fixed it

score 2 · Accepted Answer · answered Aug 16 '18 at 03:59

2

I found the solution

The problem is that "Run as" in the Job step Property was empty

changed that to BI_SSISProxy/Account now it is working

answered Aug 16 '18 at 03:59

asmgx

1

What if that `Run as` dropdown is empty? – Don Cheadle Jan 29 '19 at 21:32
@mmcrae make sure to have SQL Server Integration Service Package in the "Type" dropdown – asmgx Jan 30 '19 at 00:16

1 Answers1