You could use

SSIS with the FOR EACH container

or possibly something like xp_cmdshell 'DIR c:'.

or maybe the FileSystemObject

or perhaps a small .net application

The can all give you a list of files. It really depends on what you are comfortable with.