Yes SQL 2008 R2 SSIS can support this

Looking under "Control Flow tools"

you will find in order of use in this package

1. Script Task

2. File system Task

3. Execute SQL...

Excellent use of SSIS

however I did spot a potential bottleneck, you could potentially get stuck in loop if the process that held the file open has halted or crashed or...