Microsoft BIDS How to clear table data before new transfer? <p>I have a database from which I am pulling rows from, manipulating the data a bit and then putting into another table. Every time I run the package, it doesnt remove any data from the destination and thus grows by X number of rows each time.</p> <p>Is there any way that I can clear the destination before adding the new rows?</p>