dbTalk Databases Forums  

DTS Task Order

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


Discuss DTS Task Order in the microsoft.public.sqlserver.dts forum.



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

Default DTS Task Order - 11-08-2006 , 10:28 AM






Hi

I have a package with many tasks, which are sequentially linked "daisy
chained", I was wondering if I am not reliant on the order of execution, can
I run all these tasks simultaneously? Which would be quicker?

Kind Regards

Ricky





Reply With Quote
  #2  
Old   
Arnie Rowland
 
Posts: n/a

Default Re: DTS Task Order - 11-08-2006 , 01:52 PM






If you have many processors, then parallel execution 'may' prove to be
faster. However, you should test both parallel and serial execution and
determine which one provides the most reliable and efficient solution.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"ricky" <ricky (AT) ricky (DOT) com> wrote

Quote:
Hi

I have a package with many tasks, which are sequentially linked "daisy
chained", I was wondering if I am not reliant on the order of execution,
can
I run all these tasks simultaneously? Which would be quicker?

Kind Regards

Ricky







Reply With Quote
  #3  
Old   
ricky
 
Posts: n/a

Default Re: DTS Task Order - 11-09-2006 , 04:32 AM



Thank you Arnie. I'll give it a try.

Kind Regards

Ricky

"Arnie Rowland" <arnie (AT) 1568 (DOT) com> wrote

Quote:
If you have many processors, then parallel execution 'may' prove to be
faster. However, you should test both parallel and serial execution and
determine which one provides the most reliable and efficient solution.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to
the
top yourself.
- H. Norman Schwarzkopf


"ricky" <ricky (AT) ricky (DOT) com> wrote in message
news:ORgEgL1AHHA.3604 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Hi

I have a package with many tasks, which are sequentially linked "daisy
chained", I was wondering if I am not reliant on the order of execution,
can
I run all these tasks simultaneously? Which would be quicker?

Kind Regards

Ricky









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.