dbTalk Databases Forums  

Copy one file to three different locations...

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


Discuss Copy one file to three different locations... in the microsoft.public.sqlserver.dts forum.



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

Default Copy one file to three different locations... - 10-19-2003 , 01:34 AM






You coukld create 3 jobs then start them from a
controlling job using sp_start_job.

You could put the 3 commands into different steps in a dts
package and if they have no dependencies they should run
at the same time.

Test it first to see that running the copies together is
faster than one after another.

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.