Unable to run the batch file from remote machine using SSIS .

Asked By mary_jane 10 points N/A Posted on - 06/22/2011

Hi all,

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.

Thanks.

• Status: Open
• Question Views: 3076
• Answer Count: 1
• Vote Up 1 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By andybarteit 10 points N/A #129176

Unable to run the batch file from remote machine using SSIS .

Hi Jane,

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.

Thanks.

About andybarteit

Questions
1

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 06/23/2011
• Question Category: MS SQL Server