I tested the scripts in one of dev box in SQL2016. the results are below. Each scripts ran 100 times (at 2 different times)
Included the method suggested by Scott...

Major problem you have is to identify the file to load, can you write extended stored procedure to loop through and find out the file name to be loaded. The...

If you want to get the data in as single resultset, then rather then using select, insert the data in a temp table in the query used in  

We implemented it few years back in 2008 R2, We had one stage table which was loaded by external process one record in the table was actually one delimited record...

If you want to process in bulk (expecting more rows and lot of columns) then you can explore BCP route as well, spit all the data as txt file (using...

Thanks, nice article. it is always helpful to me.
I keep my mostly used queries in the folder in "Template Browser", that is easier way to access.

You need to approach source system, these XML tags in the XMLdoc need to be replaced with escape character. You also check if your load process is changing these escape...