I have a SSIS package in which one of the steps is Execute Task -> execute a .BAT file and launch a program (Street sweeper).
The package runs successfully when run through Visual studio. The program runs fine when only the .BAT file is run.
But a job that executes this package, it gets stuck at this .BAT file step because the program needs to be run as administrator. (There is no 'Run as Admin' check box on the properties of .BAT file) I created a shortcut to this file, configured the shortcut to always run as admin, but the SSIS package's job still fails at this step.
I need to come up with something to always run this program as administrator through the BAT file.
Any workarounds to this?
Thanks in advance!