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

Transact-SQL
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

1 Like
3

Thank you, yosiasz

4

Hello Mel,

  1. Step 1: Select XML as your file type.
  2. Step 2: Choose the XML file you want to convert to SQL .
  3. Step 3: Type in a name for your database table .
  4. Step 4: Convert your file! Here's a video showing the exact steps to convert XML to SQL in 30 seconds. D4 Software.
1 Like