Load Multiple XML Files into SQL table
Budget: £10 – £20 GBP
I have a folder with multiple XML files which all follows the same data structure. I have written some simple SQL code which loads one XML into an SQL table. I need my code to load multiple XML files into the SQL table without changing the filename every time.
Perhaps the code could be dynamic so that it first searches the directory for all XML files, then loads each XML file one at a time in the requires format. This should be quite simple to do for someone who is used to work with XML files in SQL server.
Perhaps the code could be dynamic so that it first searches the directory for all XML files, then loads each XML file one at a time in the requires format. This should be quite simple to do for someone who is used to work with XML files in SQL server.