You might get the following error when you run an SSIS package:

Microsoft (R) SQL Server Execute Package Utility

Version 10.0.2531.0 for 64-bit

Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 3:28:07 PM

Error: 2010-06-24 15:28:08.20

Code: 0xC0011007

Source: {F1B654D0-5ACB-464E-AAE5-C834596B2927}

Description: Unable to load the package as XML because of package does not h\

ave a valid XML format. A specific XML parser error will be posted.

End Error

Error: 2010-06-24 15:28:08.20

Code: 0xC0011002

Source: {F1B654D0-5ACB-464E-AAE5-C834596B2927}

Description: Failed to open package file "\\Servername\ETL\DEV\Package1.dtsx"\

due to error 0x80070005 "Access is denied.". This happens when loading a pack\

age and the file cannot be opened or loaded correctly into the XML document. Th\

is can be the result of either providing an incorrect file name was specified w\

hen calling LoadPackage or the XML file was specified and has an incorrect form\

at.

End Error

Could not load package "\\Servername\ETL\DEV\Package1.dtsx" because of error 0xC\

0011002.

Description: Failed to open package file "\\Servername\ETL\DEV\Package1.dtsx" du\

e to error 0x80070005 "Access is denied.". This happens when loading a package\

and the file cannot be opened or loaded correctly into the XML document. This \

can be the result of either providing an incorrect file name was specified when\

calling LoadPackage or the XML file was specified and has an incorrect format.\

Source: {F1B654D0-5ACB-464E-AAE5-C834596B2927}

Started: 3:28:07 PM

Finished: 3:28:08 PM

Elapsed: 0.218 seconds

 

The reason for this is that the service account/Windows account that is trying to execute the package does not have permissions to the folder where the package resides.  Someone here ran into this one today. Ugh.

Thanks

Lee

 

-------------------------

Uh no. That someone wasn’t me. My stuff always runs correctly.  Word!

glass


Posted in: SSIS  Tags:
blog comments powered by Disqus

by Lee Everest, M.S.

Poll

Do you use Azure or cloud in your organization?



Show Results

Ads

Search


Month List

Calendar

«  February 2012  »
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
2728291234
567891011
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2012 Lee Everest's SQL Server, etc. weblog