Have you tried something like http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=42 or one of the dozens of other monitoring type scripts to get an idea of whats going on when this occurs?

I've gone...

Also in agreement with the comments regarding MUCK tables. This has cropped up in various articles on the site, there really should be some moderation and/or editing process to stop...

The code posted is wrapped in a transaction so I'm assuming it has to be done in one batch. If it doesn't, I'd agree splitting the process into several batches...

If I'm understanding what your doing correctly, I'd try the insert with the source select ordered by the column that is used in the clustered index. Try it with the...

If your seeing the same issue across so many different hardware and software environments I'd suggest raise a support call rather than spend any more time trying to track down...

That is a frightening statement to see from someone that has posted almost 300 messages to these forums. God help any newbies that heed your advice!

Performance Monitor can log directly to SQL server so you may as well make use of this and read the data directly from the table created.

An alternative to learning the command line options for DTSRun is to use DTSRunUI. This is a GUI utility for choosing the package, version, setting globals etc with an option...

There are options to enable almost instant indexing of new content in SQL2000 FT. Search for 'Background update' and 'Change tracking' in books online.

http://www.codesmithtools.com

Download the latest version and try the DBDocumenter template that is included. Pretty impressive and could be extended if needs be.

"If you were to replace the Child package for some reason, like saving it after making changes, this would create a completely new VersionID, with a new time stamp and...