Re: Running two Steps at the same time

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have the branches installed now and the max parallel tasks set at 15 just
in case. But for some reason after about 9 or 10 steps it reverts back to
running only one step. It trades off the after each step back and forth until
it is complete. Very strange. It starts off fine running the branches at the
same time so I know part of it is working but for some reason it always
reverts back to running only one step at a time.

Is there a reason for this?

Again thanks for your help

"Chris" wrote:

Great Thanks Dan,

-Chris


"Dan Guzman" wrote:

Multiple steps can run concurrently as long as:

1) steps are not constrained by workflow precedence with the package

2) package properties specify max parallel tasks > 1 (default is 4)

3) the package is run from a multi-threaded app like DTSRUN or Enterprise
Manager

Note that multiple steps can be dependent on the same predecessor and
subsequent steps are free to run once the predecessor completes. For
example, you can load a staging table and then run multiple Execute SQL
tasks in parallel after the load successfully completes.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Chris" <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7C9CE8FB-55A6-4780-B5B5-10653A47EA04@xxxxxxxxxxxxxxxx
Is there a way to run two DTS steps at the same time? I need to speed a
job
up that kicks off a DTS package and in the DTS package there are many
steps.
None of them rely on each other to finish, except for one at the very end,
but I can speed it up if I branch off a few steps to run at the same time.

Is this possible?

Thanks for your help

-Chris


.

Relevant Pages

  • Re: copying data from MS-SQL to MS-Access using VB.Net
    ... Is there a reason you don't just create a DTS package and point it to ... > What I was wondering is what is the bet way to populate the MS-Access ... > Even after I execute the Update method nothing happens to the Access ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Running two Steps at the same time
    ... But for some reason after about 9 or 10 steps it reverts back to ... > Multiple steps can run concurrently as long as: ... > SQL Server MVP ... >> up that kicks off a DTS package and in the DTS package there are many ...
    (microsoft.public.sqlserver.dts)
  • Re: Help with connecting to FoxPro please
    ... directories and an 8.3 type file name. ... Your other question is how to make a DTS package delete a file. ... I created a dts package to update this .dbf ... But for some reason, when I run the package the table is neve rgettign ...
    (microsoft.public.dotnet.framework.adonet)