Home Forums Data Warehousing Integration Services Issues and performance of importing XML into SQL Server 2008 RE: Issues and performance of importing XML into SQL Server 2008

  • October 7, 2015 at 9:28 pm

    #1832204

    Sideout1972 (10/7/2015)

    With that said, when you need to transmit a complex data file which has multiple nodes that need to go multiple nodes deep, XML is a reasonable format. Attempting to normalize into flat files can require hundreds of flat files to support the structure.

    Not really. You just need 1 file per level and can usually include any attributes in the same file at the same level or the file that represents the level above the current one.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)