2008R2 Express - SSIS -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:04 pm

  #263458

  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.