Load sql server table from flat file when a folder is populated?

I want to load data into a sql server table using flat files which are ftp'ed into a shared folder. These files are sent into folders organized by date and I want to load the data in today's folder (which is a'|' delimited flat file) into a sql server table.