I need to import multiple XML files into a single SQL table. I need two things:
1) I need SQL query to create a table in SQL from the XML file so I dont have to manually create the table.
2) I need SQL import query to import bulk XML files into the table created in (1). All the XML files will be saved in the same folder. I will schedule the import to run once a day so the SQL import query would import in all XML files received that day.
See attached two example XML files that we get from third parties. The XML file is suppose to be a standard format. Any ideas?