Post reply

DTS fails when scheduled

  • August 25, 2003 at 10:46 pm

    #106026

    I am trying to pull data from an MS Access database. When I manually run the job it works fine, but when I schedule the job it fails saying it cannot locate the network path. I can run it a minute later and it will succeed with no changes. SQL server 7.0 on NT 4.0 service pack 6.0A. Any help would be greatly appreciated.

  • August 26, 2003 at 10:12 am

    #471458

    When you schedule the dts package it uses the sql Agent logon to do the dts tasks. So say the sql tasks does not have permission to access the disk where the .mdb resides you will get this error.

    Hope this helps.

  • August 27, 2003 at 1:04 pm

    #471685

    Be sure that the network path is valid in the context the scheduled job is running in. Try fully qualifying the path name (\\server\etc.....) so that there's nothing dependent on any personal mappings you have.

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

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