Unable to load the package as XML because of package does not have a valid XML format

Question

Unable to load the package as XML because of package does not have a valid XML format

bmannar

SSChasing Mays

Points: 649
More actions
January 26, 2012 at 2:03 pm

#148952

2008 SQL Server Express R2
Package created on 2008 Visual Studio Dev Edition.
When i try to execute through the Command prompt or xp_cmdhshell i get the below error, but i am able to execute when i open it on UI.
ProtectionLevel: EncryptSensitiveWithUserKey, i changed it to DontSaveSensitive and EncryptSensitiveWithPassword but still not working.
Microsoft (R) SQL Server Execute Package Utility
Version 10.50.1600.1 for 64-bit
Copyright (C) Microsoft Corporation 2010. All rights reserved.
NULL
Started: 12:51:45 PM
Error: 2012-01-26 12:51:45.38
Code: 0xC0011007
Source: {4A58B973-75A4-4E20-A3D7-3F58A3E66C4C}
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: 2012-01-26 12:51:45.38
Code: 0xC0011002
Source: {4A58B973-75A4-4E20-A3D7-3F58A3E66C4C}
Description: Failed to open package file "F:\__\dts\__.dtsx" due to error 0xC00CE508 "An invalid character was found in text content.". This happens when loading a package and the file cannot be opened or loaded correctly into the X
ML 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.
End Error
Could not load package "F:\___\dts\___.dtsx" because of error 0xC0011002.
Description: Failed to open package file "F:\___\dts\___.dtsx" due to error 0xC00CE508 "An invalid character was found in text content.". 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.

Viewing 9 posts - 1 through 8 (of 8 total)

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Can you attach the package? The error is saying you have an invalid character in the XML usually "<" or ">". Without seeing the package it's hard to say more.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

bmannar SSChasing Mays Points: 649 More actions · Answer 2

bmannar

SSChasing Mays

Points: 649

January 27, 2012 at 9:32 am

#1439472

Attached package.

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

I can't open the package because it is encrypted.

Error2Error loading PHSTI_STORE_INFO.dtsx: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. C:\Users\Jack\Downloads\Package\PHSTI_STORE_INFO.dtsx11

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

bmannar SSChasing Mays Points: 649 More actions · Answer 4

I have not set any password i am able to open in my Visual Studio.

Jack Corbett SSC Guru Points: 184394 More actions · Answer 5

If it is still set with EncryptSensitiveWIthPassword then that would be why I can't open it. You mention that in your first post.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

bmannar SSChasing Mays Points: 649 More actions · Answer 6

I have changed it to Dontsavesensitive and attached again.

Jack Corbett SSC Guru Points: 184394 More actions · Answer 7

Wish I could be of more help, but I don't see anything out of the ordinary in the package and have never experienced this problem.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

bmannar SSChasing Mays Points: 649 More actions · Answer 8

Thanks for the help, i dont see anything different. Its a simple straight forward package, I will update if i find a fix.