Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jamesd0142
Starting Member
1 Post |
 Posted - 2007-08-31 : 09:35:05
|
| Hi, i have 2 servers, i created a DTS on server1 to run some updates and run updates on external programmes, i need to call a batch file stored on server 2. when i call this batch file the i need it to run as if it was called/started on server 2.The problem...It looks like it is running as if it is being stored on server1 (where the DTS is stored) obviously this causes problems and the process fails.I have created a dts on server2 to call this batchfile, and then i added a section on the dts on server1 to call this additional dts, but this does not seem to work either.How can i call the batch file from server1 so that it runs as if it was directly run on server2.Thanks James |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-31 : 15:38:37
|
| Try set sql job to run the batch file on server 2, then start the job from server 1. |
 |
|
|
|
|
|
Running batch file via DTS