Scheduled DTS unable access file in network drive RRS feed

  • Question

  • Hi Guys ... I am trying to access a textfile on a nework drive that has permission openned to "Everyone". I am trying to access the file and import the data into a table.

    When I tried to execute it manually "Execute Package", it works fine and it will populate my table fine.

    But when trying to schedule it using local permission, it fails and the error log shows "The job failed.  The Job was invoked by Schedule 34 (License Refresh).  The last step to run was step 1 (License Refresh)."

    I have did a check on the job and found out that it fails at the step where it imports the textfile from the network drive.

    I know it could be some permission settings I have to do with the SQL Server Agent. Could anyone please advice me on any good solution to my problem.

    Thanks a lot.


    Thursday, December 22, 2005 1:53 AM