Load xml data to sql table

Question

How to do that in tsql or ssis？

Please show me step by step.

Answer 1

Hi @Jefferson,

You may follow Import XML documents into SQL Server tables using SSIS packages for details.

To use T-SQL, you may check below code.

INSERT INTO T
SELECT 10, xCol
FROM    (SELECT *
    FROM OPENROWSET (BULK 'C:\MyFile\xmlfile.xml', SINGLE_BLOB)
AS xCol) AS R(xCol);

Check https://learn.microsoft.com/en-us/sql/relational-databases/xml/load-xml-data?view=sql-server-ver16

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.