I have around 500 files which are named file_27072009.txt, file_28072009.txt, file_28072009.txt etc and I need to load them all into a table. What is the easiest way to pick up each of these files in turn and load them into the sql table?
I have access to SISS or sql server mgt studio but am not an expert in either.
Any help would be much appreciated so I am not having to manually open and merge all the files into one before loading.
Thanks so much
View Complete Post