Performance problems loading XML with SSIS, an alternative way!
- by AtulThakor
I recently needed to load several thousand XML files into a SQL database, I created an SSIS package which was created as followed:
Using a foreach container to loop through a directory and load each file path into a variable, the “Import XML” dataflow would then load each XML file into a SQL table.
Running this, it took…