Search code examples
ssisssis-2012

SSIS Error : Non-SysAdmins have been denied permission


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


Solution

  • 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