dbTalk Databases Forums  

Execute Multiple .bat files simultaneously

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Execute Multiple .bat files simultaneously in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Liz
 
Posts: n/a

Default Execute Multiple .bat files simultaneously - 04-25-2006 , 09:31 AM






SQL 2000 sp4
Does anyone know how to execute batch files simultaneously in DTS? For
performance, I need 4 batch files to execute at the same time. NOT batch1,
then batch2, then batch3 and finally batch4. All four must start at the same
time. When they end is of no importance.

Thanks in advance,
Liz

Reply With Quote
  #2  
Old   
Slice
 
Posts: n/a

Default Re: Execute Multiple .bat files simultaneously - 04-26-2006 , 10:59 AM






DTS does not allow for this level of control. Do you need to review
their return status or is that also in the "whatever" category?

I ask this because without getting too complicated... as there are
always fancier ways such as wshshell (windows scripting host objects)
that have .execute and synchronous vs. asynchronous modes... bla de
bla.

Consider creating a single firethemall.bat file that contains:

start first.bat
start second.bat
start third.bat
start fourth.bat

The start command is pretty versatile - from DOS prompt type START /?
to review more options.

Cheers!
http://rickhathaway.blogspot.com/


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.