Post reply

DTS package

  • May 8, 2008 at 12:38 pm

    #190184

    Hi,

    I have DTS package which was running fine since long time but failing now. It is failing when kicked off by Autosys job. If I execute it manually it works fine. I am getting the below message.

    DTSRun OnError: DTSStep_DTSExecuteSQLTask_9, Error = -2147467259 (80004005)

    Error string: The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data.

    Error source: Microsoft JET Database Engine

    Help file:

    Help context: 5003051

    Thanks in advance.

    Sam.

  • May 8, 2008 at 12:57 pm

    #812631

    Do you have it open? Or does the autosys have permissions to open the file?

  • May 8, 2008 at 1:28 pm

    #812651

    The file is not open and the Autosys ID has admin rights.

    Thanks

    Sam.

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

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