Scheduling in SQL 7

Results 1 to 2 of 2

Thread: Scheduling in SQL 7

  1. #1
    Join Date
    Dec 1969

    Default Scheduling in SQL 7

    I have constantly changing information sent to my server in the form of a tab delimeted text file. I want to setup SQL to reimport the file every two hours. I have tried creating the DTS package and scheduling it but it keeps failing to run. The SQLserveragent is running on the server. Anything else I should do to get this thing running?

  2. #2
    Join Date
    Dec 1969

    Default RE: Scheduling in SQL 7

    Do you get any error messages?<BR><BR>Does the DTS package run when you execute it manually?

Posting Permissions

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