I need to execute a bat file inside of a scheudle SSIS package. The bat file calls a PSExec command to start a SAS job on a dedicated SAS server. This bat file is called in a Process Task with the executeable defined by a variable built by expression. I confirmed the variable is loaded correctly.
Running from BIDS it works as designed; from SQL as a schediled SSIS job, it hangs on the call to the Bat file.
With PSexec I am passing a login and password for the SAS machine so permissions should not be a problem. PSExec is installed on both machines.