Post reply

Extract XML file with multiple element into sql server using SSSI

  • December 3, 2010 at 12:35 pm

    #243596

    Hi Everyone,

    I am new in SSIS. I have to extract XML file with multiple element into sql server.

    I succefully extract XML file using XML source and loaded it into the SQL server table.

    That XML file going to create more than 40 tables becouse its in the normalize form. I just one want 8-9 main table which contain all the attributes.

    How can I do it.

  • December 5, 2010 at 3:33 pm

    #1258846

    Without knowing what's your input XML file, I would say use the standard Merge component to combine inputs into a merged view. You will need key columns to make this work.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 2 posts - 1 through 1 (of 1 total)

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