DTS Package on SQL 2005, after upgrade

Discussion in 'microsoft.public.sqlserver.dts' started by Jason Fisher, May 20, 2010.

  1. Jason Fisher

    Jason Fisher Guest

    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!
    Jason Fisher, May 20, 2010
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.