Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSIS Error : Non-SysAdmins have been denied permission

Tags:

ssis

ssis-2012

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

like image 816
asmgx Avatar asked Sep 13 '25 00:09

asmgx


1 Answers

I found the solution

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

enter image description here

changed that to BI_SSISProxy/Account now it is working

like image 150
asmgx Avatar answered Sep 16 '25 05:09

asmgx