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