To run that code you will need a SQL Task in the Control Flow view. You probably should save the table name to a global SSIS variable so you can reference it in other places if you are trying to populate it. I'm still not 100% convinced you need a table for each run. Generally you put a time stamp on a record to determine when it was inserted, but you may have a practical application.

Cheers,

Brian