Thank you for this post. Just saved the day for me (downgraded SSIS package from 2008 to 2005 successfully!)

Thank you for your replies. The information was right on.

I created a scratch table in the database (orders_del) that is just being used to hold the order#'s to be...

I tried with removing all the indexes from the table, except for the one being used, and then reran the task. The results were the same - no speed...