SQL Server - Different ways to shred XML into table

 SQL Server - Different ways to shred XML into table :

1.) Using OPENXML or nodes()

2.) SSIS - XML Source task

3.) Powershell  

4.) Using VB/C# script (Script task in SSIS)

5.) Using SQL XML Bulkload API

 Reference links :

SQL Server XML Bulk load examples

SQL Server - Import/Shred XML from XML file placed in a folder into table

SSIS - Shred data from XML file in folder into columns of a table

Best Way to Shred XML document and insert the result set into a table in SQL Server

See Also :

No comments: