I have written a load script that should load all filenames in all the subfolders. I believe there should be approximately 600 csv files in all of the subfolders. I believe this script should do the job. However, the load script seems to be running for ages. The script has been running for an hour and is still going. Is there anything about my script that could be altered to make it run more efficiently?
SET MoneyFormat='€ #.##0,00;€ -#.##0,00';
SET TimestampFormat='D-M-YYYY h:mm:ss[.fff]';