none
Encounter error when deploying SSIS- Failed to load XML due to error 0xC00CE554 "Duplicate attribute. Line 16, Column 60"

    Question

  • Encounter the following error when deploying an SSIS package to server, any idea?  

    TITLE: SQL Server Integration Services
    ------------------------------

    Failed to load XML due to error 0xC00CE554 "Duplicate attribute. Line 16, Column 60". This occurs when loading a package and the file cannot be opened or loaded correctly into the XML document.  This can be the result of specifying an incorrect file name to the LoadPackage method or the specified XML file has an incorrect format.
     ({FCD7E0D9-A4E5-4F6F-9B64-9F0F9A9F3E69})


    Sharpening

    Monday, July 14, 2014 8:39 AM

All replies

  • Is this happening in SSIS 2012 using project deployment model?

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Monday, July 14, 2014 8:44 AM
  • I suppose so.

    Sharpening

    Tuesday, July 15, 2014 6:37 AM
  • Do you have multiple packages with same name coming inside same SSIS project?

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Tuesday, July 15, 2014 7:07 AM
  • Hi Sharpening,

    Please try to create a new SQL Server Intergation Services project and add existing package into it to see if this issue still persists.

    If you have any feedback on our support, please click here.


    Elvis Long
    TechNet Community Support

    Wednesday, July 16, 2014 5:39 AM
  • Thank you guys.

    It's really a weird a issue. I have managed to resolve the issue by copying those files in the project from another branch, and then deployment is successful. 

    Honestly I don't find any file with duplicate name. So the root cause remains unknown.

    Anyway, this gives a lesson that it's always worthy to keep a working backup. 


    Sharpening

    Wednesday, July 16, 2014 7:52 AM