August 5, 2015 at 3:46 am
Hi Friend,
Please help me. I am getting below Error in SQLServer Job Agent
Date 8/5/2015 3:05:57 PM
Log Job 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
Does the sql agent job account have rights on C:\Ram.dtsx? (on the sql server)
August 6, 2015 at 10:52 pm
Yes. This is package having rights
August 7, 2015 at 7:09 am
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
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