Post reply

.XML" could not be opened. Operating system error code 5(Access is denied.).

  • February 21, 2010 at 12:38 am

    #1122448

    Set your database to TRUSTWORTHY.

    (also, please be aware that this has security implications).

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • February 22, 2010 at 6:48 am

    #1122909

    I have worked around the issue with an SSIS package, I am aware of the Trustworthy option and the security implications which is why I opted not to use it.

    I have created an SSIS Package with for loop to move the files from the UNC resource to a local resource; the xml files are then processed and deleted for those processed successfully.

    By using SSIS I am able to build in a little more advanced error handling as well.

    Not ideal, but I do prefer it to the Trustworthy option.

    Thank you for your feedback

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

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