As you probably already know, DTS was not made for looping.
I would probably do the looping inside an ActiveX script and have the script call the next step, passing the required information. How, good question.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]