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:

Add comment




  Country flag

biuquote
  • Comment
  • Preview
Loading




by Lee Everest, M.S.

Search


Ads

Calendar

«  September 2010  »
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
27282930123
45678910
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 2010 Lee Everest's SQL Server, etc. weblog