SQL Server Performance

DTS Permission

Discussion in 'General DBA Questions' started by brianl, Feb 12, 2003.

  1. brianl New Member

    We just installed Service Pack 3.
    Now our DTS won't work.

    The first task that executes is an ActiveX script that copies files from one server to another.
    It give the error: "File does not exist"

    It will work in design view (If I click the play button)
    But it does not work when the job is scheduled.
    Are there permission issues that I may be over looking?
    Can I set the executing user??

    Thanks,
    Brian Linden
  2. satya Moderator

    Its not problem with SP3, its the account used to run the job.

    Make sure the SQLAgent has got admin privileges on both the machines to copy the file, being its scheduled and controlled by SQLAgent via job scheduler.

    Refer to books online for DTS permissions topic.

    HTH

    Satya SKJ

Share This Page