Couple of things, first if this is really an SSIS question you might have better luck posting it in the SSIS forum. Secondly, yes SSIS is one way to do this, there are a variety of others, Powershell, Perl and javascript all come to mind as well as batch files with sqlcmd.exe.
Perhaps you can elaborate on exactly what you're stuck on in creating an SSIS task? This might be a good starting point for you.
http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx
-Luke.
To help us help you read this[/url]For better help with performance problems please read this[/url]