Post reply

JOb Agent Error

  • August 5, 2015 at 3:46 am

    #303090

    Hi Friend,

    Please help me. I am getting below Error in SQLServer Job Agent

    Date8/5/2015 3:05:57 PM

    LogJob History

    Message

    Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 11.0.5532.0 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 3:05:57 PM Error: 2015-08-05 15:05:57.48 Code: 0xC0011007 Source: {C36624C6-00B6-4853-956F-5E6F411934FF} Description: 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: 2015-08-05 15:05:57.48 Code: 0xC0011002 Source: {C36624C6-00B6-4853-956F-5E6F411934FF} Description: Failed to open package file "C:\Ram.dtsx" 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. End Error Could not load package "C:\Ram.dtsx" because of error 0xC0011002. Description: Failed to open package file "C:\Ram.dtsx" 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. Source: {C36624C6-00B6-4853-956F-5E6F411934FF} Started: 3:05:57 PM Finished: 3:05:57 PM Elapsed: 0.016 seconds. The package could not be found. The step failed.

    Thanks

    Rambabu

  • August 5, 2015 at 4:41 am

    #1817429

    Does the sql agent job account have rights on C:\Ram.dtsx? (on the sql server)

  • August 6, 2015 at 10:52 pm

    #1818017

    Yes. This is package having rights

  • August 7, 2015 at 7:09 am

    #1818083

    1)Right click on that specific folder go to properties

    2)select security window

    3)under that select your current user name

    4)click edit

    5)select full control

    6)click apply and ok.

    And then try.

    Regards,

    Saravanan S.

  • August 10, 2015 at 4:34 pm

    #1818779

    What happens if you place the package in a subfolder like c:\packages\ram.dtsx?

Viewing 5 posts - 1 through 4 (of 4 total)

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