SQL Server Performance

DTS never finish

Discussion in 'General Developer Questions' started by RubenN, Dec 2, 2009.

  1. RubenN New Member

    Hi,
    I have a DTS that running 3 sp, they process a lot of data, and was running 21 hours and don't finish.
    I simulate the DTS, make a .bat that run the 3 sp using osql command, and run in 30 minutes.
    ¿what is the difference?
    Thanks,
    RN
  2. satya Moderator

    Welcome to the forums.
    It is not the problem of DTS, it is how you are executing.
    Did you check whether any blocking is happening whiel these are executed?

Share This Page