Results 1 to 2 of 2

Thread: Export data

  1. #1
    Join Date
    Aug 2003

    Unanswered: Export data

    I use the DTS to export data to an Oracle table. However, I want to do this automatically. I want to use the scheduler in the SQL Server DTS, but after setting up the job in 'Local Packages', the time comes and goes and nothing happens. Is there some log file I can see why the package didn't run?
    Last edited by exdter; 11-10-03 at 18:56.

  2. #2
    Join Date
    Nov 2003
    Christchurch, New Zealand
    If you view the job history it will show when the job tried to run. There is a tick box on this screen that will let you see what happened with individual steps.

    This should show you something along the lines of the error (depending on exactly what the error was).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts