You might want to use Konesans File watcher object http://www.sqlis.com/post/file-watcher-task.aspx

In the control flow, execute an sp or some sql to get the asign the results to a result set (Object variable) then use a ForEach Loop Container.

You...

Have you set the script component logging on?

I think it's called ScriptTaskLogEntry