Trying to open multiple CMD.EXE's to run simultaneously in my DTS Package
Posted on 2004-08-24
I have a SQL DTS job and at one point, I call five concurrent DOS processes in an attempt to spawn 5 file copy processes simultaneously.
Each of the 5 concurrent DTS steps runs a batch file that copies a file from a remote server to the local machine. I am calling the batch file like:
In the batch file, I have
copy MyFile c:\Files\
I thought that by using start and exit, my 5 DTS steps would cause 5 CMD.EXE's to be opened simultaneously, but when I watch Task Manager, I see one CMD.EXE, although the Process ID is changing constantly as the files are copied.
Can anyone tell me if this is working normally or how to cause 5 separate CMD.EXE's to be opened simultaneuosly?