What is the nominal load that can be handled by DTS?

For eg: if 1 GB data need to be loaded, can DTS handle this? Any pointers
will be helpful.

Thanks!

yes, DTS can do this.
because the limit is more at the DB and hardware level.
also, just be sure about what you do.
doing a row by row transformation (I mean using a VBscript to convert
comething) will break your bulk loads.
so try to use good and optimized Select statements.

there is some options in the DTS pump tasks to play with and to optimize the
performance.

I'm writing a table with 20 millions of rows on a Raid 0+1 (4gb, 2proc)
system at 70 000rows/sec (write cache enabled)
another server with a raid 5 (4gb, 4proc) (write cache disabled) do the
same job at 30 000rows /sec
has you can see the hard drive subsystem is important.

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

Sankar, I would look at implementing C++ custom transformations. The
performance overhead for using an automation/COM interface to processing a
row by row transformation using a language C/C++ other can be overwhelming.
Please let me know if you need any more help if you considering using C++
custom transformations. Thank you

--Thought for the day--
"The greater fool is the person who takes offense when offense is intended"


"Sankar" wrote: