Scheduled DTS task fails.. not sure what step?

  • I have scheduled a DTS package to run at night. There is about 30 different steps involved ranging from bcp to external run commands. It has been running along fine accept for the last few days its been failing. I view the job hisotry and it tells me it fails but the little 'blurb' doesn't tell me at what step it fails. If I run it just from the enterprise manager it runs fine. Scheduled seems to bomb out regularly. Is there anyway to get a more detailed report as to what step actually failed? I have checked the logs on all servers that are being used but nothing of any consequence. Any assistance would be greatly appreciated. Thanks

  • U can run a profiler when the job runs and see where it bums and act accordingly.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply