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
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?