GitHub repository: msornakumar/Load-Complex-XML-to-SQL-Server
Created: 2017-12-13T00:09:25Z
Description: This generic SSIS script code loads any complex XML data into SQL Server Database. The table structure based on the XML structure is created dynamically and the data is loaded. There is an option of making this to work as Framework with Framework tables to store the File details and load the relationship between the tables in the XML File. The script loops through the XML files provided in the path and loads the data into the SQL Server database. All these values are configurable.