Scheduled SSIS task hanging on execute process task

Question

Hi we have a SSIS package that calls an execute process task. The task accesses a saved sql file in the directory, the agent that runs our task does have permission to access all these files. Yet when the package is executed it hangs at the execute process task, no processes are running but the package still is, all the previous tasks complete successfully until it reaches the execute process task

Answer 1

Hi if anyone is looking for the same problem we came across the answer, the cmd window required user input and therefore could not continue with the process until the cmd process task has finished and it never does.

So in short make sure your cmd process doesnt require user input if you are deploying to SSISDB or it will hang and you cant do anything about it