Wednesday, February 15, 2012

Execute Command Process - remote batch file?

Good afternoon-
Can a batch file that resides on another server be executed from a different machine? I have a batch file that resides on a server that I would like to run using SQL 2005 Integration Services. Is there anything I can do that would allow me to remotely execute this batch file and have it run in that environment.
BATCH FILE:

cd C:\Trandev\
otrun -at OTRecogn.att -DINPUT_FILE=%1 -tl 1 -cs dv -lg mylog -I
C:\Trandev represents the remote environment


I have tried mapping the remote machine to a network drive on my local machine and using that drive to execute the batch file in an Execute Process Task, but it does not work.

SSIS:

I have a FOR EACH loop grabbing files and writing fileName to a variable that is passed to the Process Task as an argument through an expression(%1 in the batch file above). The Working Directory is a mapped network drive. The Executable is also a network drive plus batch file name.


Any help would be appreciated.
My computer is a HP Compaq dc7100, 512mb RAM, WindowsXP

An error message (if there is one) is more use than just saying "it doesn't work".

-Jamie

|||

[Execute Process Task] Error: In Executing "V:\z_811Test.bat" "edi_txt_test.in383" at "V:\", The process exit code was "1" while the expected was "0".

V:\ is a mapped network drive representing the environment where I wish to run the batch file.

James

No comments:

Post a Comment