N/APosted on - 06/22/2011
In SSIS, while I was trying to run a batch file from a remote machine using the Execute Process Task, it was giving error and the task was getting terminated from the process. I have set all the properties correctly in the Execute Process Task. But the local batch file was running perfectly without any issues. Please help me to resolve this issue.
Unable to run the batch file from remote machine using SSIS .
While dealing with a batch file, check whether you have used the local machine command prompt. In case of trying to run the batch file from a remote machine, you can use the power shell command. These are ways of executing the batch file through command prompt.
If you are trying to run the batch file from a remote machine using the Execute Process Task in SSIS, then check you have selected the remote machine command prompt in the directory option. This works only if the local computer has permission to access the remote computer's windows directory.
If the computer has no permission for accessing the remote computer's windows directory, then you can map the network drive to the local computer and use the local computer's windows directory to execute it.. Hope this would solve the issue. If the issue still exists, please get back to me.