when you say 100 tables how exactly have you running your package, loading is done individually like data flow task (hardcoded destination table) or you are getting it from anyother source ?

because if you are getting these from a table/other source, then you can use FOR Each loop container, in that container you can get the name of the table in to a user variable and rest come be done the same as you have written. Make sense ?