Post reply

DTS package fails under agent, but works via command line

  • March 21, 2017 at 9:02 am

    #319808

    Hey all,

    At a loss here. Have a DTS package that is failing when running via the agent. It's clearing stating that there's a security issue:
    Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted. End Error Error: 2017-03-21 10:55:33.43  Code: 0xC0011002  Source: {EB69F569-1371-4B2F-AF5C-B1DA0A3E8070}  Description: Failed to open package file "<Package>" due to error 0x80070005 "Access is denied.". This occurs when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of specifying an incorrect file name when calling LoadPackage or the specified XML file has an incorrect format. 

    Yet, using dtexec.exe, works like a champ: DTExec: The package execution returned DTSER_SUCCESS (0).

    Using the same service account for both tests - agent and command line. Further, this account absolutely has read/write to the folder, and to the package. I've moved the package to a different folder, same scenario - dtexec works, agent does not.

    Any thoughts?

    Thanks

  • March 21, 2017 at 9:14 am

    #1934174

    Well, it was security ... the file system was being called by using the hidden share $, which that account can't access. Changed to actual path and it worked fine.

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

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