Post reply

Access Denied errors with scheduled jobs

  • May 29, 2006 at 1:39 am

    #112424

    Hi,

    I am fairly new to using DTS and I am having trouble with scheduling jobs. I get flat files dumped onto one of our servers and need these imported on a daily basis. I have set up DTS packages and scheduled them at various times. This has been working well for the last few months, but has suddenly stopped working since yesterday. The packages still run fine if I just execute them, but the scheduled jobs don't work.

    When I checked the package logs I found the following error:

    "Step Error Source: Microsoft Data Transformation Services Flat File Rowset Provider  Step Error Description:Error opening datafile: Access is denied.    Step Error code: 80004005  Step Error Help File: DTSFFile.hlp  Step Error Help Context ID:0  "

    I have scanned some forums which seem to suggest checking the SQLAgent account, but I am very new to this game and am not sure what exactly I should be looking for and where.

    Help anyone?

    Thanks in advance!

  • May 30, 2006 at 6:16 am

    #640653

    Hi,

    I just fixed a problem like that this morning myself.

    go to services in control panel, and make sure that the SQLSERVERAGENT service logon account has access to the folder where the files are located. (its this that runs the scheduled DTS). See if it makes any difference.

    cheers

  • May 30, 2006 at 6:47 am

    #640661

    Hi,

    Just found out serverops changed the domain without telling me

    Thanks so much! I learn something new everyday!

    Cheerz

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

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