Re: DTS Pegs the CPU 100%

#1

I would

A. Isolate what in the package pegs the CPU
B. What SP of 2000 (SQL) are you running?

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Chris Kelly" <chriskelly777 (AT) hotmail (DOT) com> wrote

Quote:

I have created several DTS packages that peg the processor
at 100% for the length of the process which could be 40
minutes sometimes. Most of these packages are transfering
data from Excell into SQL2000 or transfering data from
Excell into Oracle 8i . Is there a way to limit the amount
of processor usage
Thank you
Chris

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: DTS Pegs the CPU 100%

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

Re: DTS Pegs the CPU 100% - 10-03-2003 , 12:55 PM