• Maybe you need to be a little more specific in your questions.

    Need an Answer? Actually, No ... You Need a Question

    That being said, there are several options to do this.

    You can use SSIS for example with the XML source or you can use XSLT to transform the XML file to a CSV file and then import it with SSIS or bcp. Or you can bulk import it using OPENROWSET to a staging table and then use XQuery to shred it to individual rows.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP