SQL Server Performance

DTS Failed

Discussion in 'SQL Server DTS-Related Questions' started by BugMe, May 3, 2006.

  1. BugMe New Member

    I have scheduled a DTS to run at 2PM and 6 PM. It runs fine at 6PM but fails at 2PM. Is there a way to find out why it fails at 2PM?

    Thanks

    Bugme
  2. satya Moderator

  3. BugMe New Member

    By looking at the job history, it seems like the job failed while copying data from database to database. I manually ran it and it worked fine. The DTS is working becuase it runs fine at 6PM but not 2PM. Is it possible that it fails copying the data at 2PM because users are in the system using the tables? I can't think of any other reason for it to fail at 2PM but not 6PM. Any suggestion?

    Thanks

    Bugme
  4. mmarovic Active Member

    What was the error reported?
  5. satya Moderator

    True and that gives more idea.
    Make sure there are no network issues during that stipulated time, ensure the SQLAgent has required privileges to copy the files between the servers.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  6. BugMe New Member

    The error simply stated.... "Process Exit Code 1. The step failed."
    The two databases are resided on the same server. So, there shouldn't be any privileges problem, right?
  7. satya Moderator

    Enable the DTS package logging for more information on the error, refer to books online to enable the logging for DTS.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page