Microsoft BIDS How to clear table data before new transfer?

Question

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.

Is there any way that I can clear the destination before adding the new rows?

When you say 'pulling' rows, are you just running a query on the data? If so this won't actually remove the rows from the database, you would need to run a separate delete query to do this. — robjohncox, Aug 06 '13 at 18:35

score 0 · Accepted Answer · answered Aug 06 '13 at 18:36

0

YOu can run a truncate statement to clear all records from the table.

TRUNCATE TABLE YourTableName

answered Aug 06 '13 at 18:36

Declan_K

6,726
2
19
30

Microsoft BIDS How to clear table data before new transfer?

1 Answers1