I am actually wrapping up the process of changing the values to see what results I get.  As you can imagine, it is a tedious process.  The more I test, the more...

Great response, Greg.  Thank you.

I looked into the Insert Batch Size option and you were right.  I changed that value from zero to 50,000.  My baseline runtime for that copy...

It seems that the concensus is to use default instances when possible.  Though most of our apps are web based, it does seem that named instances will not alleviate the...

If you are dealing with a massive table, there may be a cleaner way to do this, but off-hand this will do the trick.  I am not sure of your...

Thanks for the response, Greg.  That pretty much bursts my bubble and is exactly what I needed to know.  I guess my next question becomes:

Does anyone have a +5 Wand of...

Another good idea, Joseph.  We don't have too many 2k workstations left, but I found one and tried it.  Unfortunately, I get the same results.  I've been doing some surfing...

Thanks for the suggestion, Steve.  I saved the "broken" package from the 2k3 server to a structured storage file.  I went to a workstation and attempted opening the package from...

Not sure if this applies to you, but when I'm concatenating various strings into one sql string that I want to execute, explicitly casting variable with the cstr() function helps to avoid those...