Home Forums SQL Server 2005 Business Intelligence how to Import XML data into one single table in SQL server using SSIS RE: how to Import XML data into one single table in SQL server using SSIS

  • September 9, 2016 at 10:11 am

    #1900105

    hegdesuchi (9/9/2016)

    Hi,

    OPENXML works fine if all have single parent node.

    But I might want columns for different nodes. Do we have any option?

    Thanks

    Post a sample of the XML you're working with and desired results. I'm pretty sure I can show you a few ways to tackle this.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001