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?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • @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!

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • 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