SQLTeam.com | Weblogs | Forums

XML to SQL Database/Table and SQL Database/Table to XML


Hello all,

How do I load the data form xml file to my sql database/table? I need to load those data to a table so I can query and output the data back to XML?



you can use either SSIS packages or powershell to ingest these xml files into sql server.

here is a sample video


Thank you, yosiasz