First, let's take a look at getting your table of information into an SSIS variable. You will need to add a new variable to the package with a Data Type of Object.

Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation.