DTS and processing order

I have a set up DTS packages that I have set up to run every night.
Each package copys a table from a foreign database to our SQL Server
2000 system.
There are about 60 packages and some of the files have over half a
million records and take a little time. I have a package that calls all
of these as sub tasks. Is there a problem with just letting them run -
with no precedence constraints set.?
I have heard that you shouldn't run more that about 4 packages or so
packages at a time in parallel. If this is the case, do I have to set
them up one after another serially?
Also, if I have a one processer system, will running them in parallel
help me at all?
Thanks,
Tom.Hi Tom,
There should not be any problems executing multiple Packages at the same
time.
SQL Server would process the individual tasks appropriately, It would not
start processing more packages, then what it can handle, depending upon the
available resources.
Regarding precedence of the packages : This mainly depends upon the design
of your database. If you have defined constraints on the tables, for which
you are importing the data, then you may have to keep the constraints in
mind and then set the precedence for importing the data. So that the import
process of the dependent table does not fail, due to non availability of
the records in the master table.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.