Is there a way to limit the CPU utilization that a DTS job uses.

Design is the only option. DTS is simply a GUI over the top of OS, TSQL
commands etc etc. It cannot optimise your SQL Statements or tell the OS to
do something in a different way. What part of your DTS packages are having
problems? Do you have problems running these things external to DTS? What
version and Service pack are you running both OS and SQL Server?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"AA" <AA (AT) discussions (DOT) microsoft.com> wrote

All you can do is lower priority of a step on OS level. This will allow
other processes outside DTS to move ahead.

Ilya

"AA" <AA (AT) discussions (DOT) microsoft.com> wrote