Good news, I found the run as dropdown on the General page of the Job Step properties dialog, not the Advanced page like I saw in a screen shot online,...

Not finding anywhere to associate the proxy with a server role. 🙁

Actually there's something in the SSIS package context menu that says Package Roles... where I see my package has...

I'm unable to find where proxy run-as is configured in Job or job step. Should it just automatically use a proxy in the SSIS subsystem?

@hjackson57

I verified the login used by the proxy has read/write access to the database, as well as read privileges on the network share. It is set up under...