I have several hundred files in a windows directory that I need to get into a CSV list for import into a SQL table. This is a quick and dirty way to create a flat file with just the file names:
dir /b > mycsv.txt
Run that from a command prompt having navigated to the folder in question to generate your file. To return the complete path of the file:
dir /b /s > mycsv.txt
You can drop the switches to get all the information the dir command returns.
DTS/SSIS/BCP this file into SQL and away you go. Hope this helps!