SQLTeam.com | Weblogs | Forums

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


#1

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?

Anyone?


#2

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

here is a sample video


#3

Thank you, yosiasz