We are having a strange problem with a DTS package running on SQL 2005 after
our upgrade from SQL 2000 this week. The first step of the package just runs
three stored procedures. We can run these SPs individually, and they execute
pretty quickly, massaging and transferring data in just a few minutes, but
when they are part of the DTS package, execution gets hung up on this first
step and takes hours to complete. We are only talking about maybe 100,000
rows of data. So, why would this be?

Does anyone know any reasons why simple stored procedure execution in a
legacy DTS package would get hung up like this? Any suggestions for
troubleshooting (besides rewriting in SSIS, which is on the to-do list but
won't happen right away)? Anything we could be looking at?

Thanks for any help!