Hi

I have a SQL Server instance running on a Windows Server 2003 box with
4 processors. SQL Server is configured to use all 4 processors, and
use all available processors for parallelism.

I have created a simple DTS package which has 2 "execute external
process" tasks with no precedence constraints between them. There are
no connections required or defined for the two tasks (sequential
processing is forced on tasks sharing connections). The DTS package
properties have the "limit the number of tasks to execute in parallel"
set to 4.

However, despite the above configuration, the two steps are never
executed in parallel, but always sequentially.

Does anyone have any ideas as to why these tasks are not being executed
in parallel?

Any suggestions welcome.

Thanks.