Calling stored procs based on a code table

I need to run stored procs based on a list in a code table. In other words, it reads the name of a stored proc from a table and runs it and does this for all the rows in the table.I think the ForEach loop container will do what I need and there is an ADO enumerator option but the documentation does not tell you how to use this.From what I can tell, you need to get a dataset into an SSIS variable first and then you plug the variable name into the ForEach ADO enumerator.Is that correct? If so, can someone tell me how to get a dataset into a variable?

Thanks

Perhaps kirk's blog will help you:

http://sqljunkies.com/WebLog/knight_reign/archive/2005/03/25/9588.aspx