How to clear all contents in a table before exporting data to that table using SSIS package?
I want to export data from a SQL database table to a Access database table. However, I want the Destination table to be cleared everytime before the exporting takes place. Can anyone advise me on this? Thks alot.