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 anExecute 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
February 23rd, 2006 6:09am
An error message (if there is one) is more use than just saying "it doesn't work".
-Jamie
Free Windows Admin Tool Kit Click here and download it now
February 23rd, 2006 11:28am
[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
February 23rd, 2006 9:34pm
Hello -
Did mapping the drive of remote machine on the server where SSIS is running work ? i have a similar situation.
My ssis package(execute process task) is running on ServerA and the Address.exe is running on ServerB.
When i execute my package itsimply says itexecuted successfully...but itdid not actually execute. The exe issupposed to update some records in the database. If i login toServerBand execute the exe, it works just fine.
Please suggest....
Free Windows Admin Tool Kit Click here and download it now
July 30th, 2008 4:10am
When you executea batch file from a network share, you're executing it on the local machine, not the remote machine.
If you want to execute a program on another server, you can use a stored procedure on that server to invoke the command, and call that stored procedure from the local mcahine.
You could also create a web service on the remote server that invoked the command you want to execute.
In either case, be very careful that you don't open a security hole by either allowing more users to execute commands through the mechanism you implement, or by some user to execute commands other than the one you intend.
August 3rd, 2008 8:32pm
Hi every one,
i have same issue. i want ot call a bacth file using process task in ssis. but i try to run on same machine from where i am calling this and gives me error. can any other way i can run it on remote machine. actuallymachine where this file is saved is a application
server we can not intall sql server to create a store procdure and even security will not allow to create a web servoces.
Free Windows Admin Tool Kit Click here and download it now
January 9th, 2011 3:00am
video converter to avi
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
January 10th, 2011 12:23am
Hello...can u pls give me an example or link that shows how to make it?
Free Windows Admin Tool Kit Click here and download it now
February 10th, 2011 6:37am
This topic is archived. No further replies will be accepted.
Other recent topics
