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!

598f52b4-8df1-4154-9842-2351b5684ad2|0|.0