I have an unusual question. Hope someone have an answer to help me.
I am triggering a batch file residing on SERVER1.
Inside the batch file is the command that looks like this:
CMD /C \\SERVER2\DTS32Binn\DTExec.exe /sq Create_Data_File /ser SERVER2 /SET \Package.Connections["Configuration"].Properties["ServerName"];\""SERVER2\"" 1>>\\SERVER1\Folder1\Folder2\Folder2\XXXXXX_log.txt
(Run SERVER2/DTS32Binn/DTExec.exe process using additional data supplied in the batch file, create XXXXX_log.txt file and put it in the \Folder1\Folder2\Folder3 folder on SERVER1.
The process is executing O.K. and I am getting what I am expecting to get. The only problem I have is that the process is physically running on the SERVER1 (The server where the batch file is residing). I need this process to run physically on the SERVER2. I am not able to move the batch file to the SERVER2 and execute it from there because of my company’s internal reasons.
Is there any simple way, using a DOS command in the batch file, to force the process triggered on the SERVER1 to run physically on the SERVER2.
Any help will be greatly appreciated.
Thanks in advance,