Ok, so I read that as you need to empty the destination table.

On the Control Flow of the SSIS package add a Execute SQL Task, chose the correct connection, and put in a TRUNCATE TABLE command for the table you need to empty, connect the Exec SQL task to the Data-Flow task and you should be in good shape.

CEWII