Format of the XML in the dtsx?

  • Hi,

    I tried to understand the structure of the xml in the package. When I format the xml, afterwards the package cannot be loaded. "Error loading ..."

    How can that be? Is there a documentation? Or anybody who knows the rules well?

    To

  • Not sure if this is what you're loooking for, but microsoft has published some of the XML schemas used by SSIS, SSRS and other components.

    http://schemas.microsoft.com/sqlserver/

    [font="Verdana"]Markus Bohse[/font]

  • tobe_ha (6/9/2009)


    Hi,

    I tried to understand the structure of the xml in the package. When I format the xml, afterwards the package cannot be loaded. "Error loading ..."

    How can that be? Is there a documentation? Or anybody who knows the rules well?

    To

    I'm interested - why are you trying to do this?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • @Phil: I just like to play with c# in my hotel room. I wondered if i could write a command based tool to build or update SSIS-Packages.

    So I tried a little with class XmlDataDocument and xpath .. fine

    But I'm running against the above mentioned wall, when I save the dtsx.

  • Wow, that's what I call dedication - get that man a beer!

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • just in case..

    Indeed I have no problems, when I keep the format of the content.

    this helped me:

    http://bytes.com/groups/net-c/652496-how-update-xml-file

Viewing 6 posts - 1 through 5 (of 5 total)

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