You need to find some way of enumerating the files in the folder and then processing them one by one. That may be by running a dir command via xp_cmdshell and dumping the results into a temp table, it may be a Powershell script that you write, or you could create an SSIS package for it.

John