May be there is a better way, but you can generating a datatable from source and load it to destination if the process is successful, execute the drop table query.
If you have the better answer, then send it to us. We will display your answer after the approval.