Instead of a data flow, you need an Execute SQL Task as Daniel mentioned.

Just put an INSERT INTO <table> before all your queries in your source table and execute it like a regular SQL statement.