• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1393
  • Last Modified:

How to clear all contents in a table before exporting data to that table using SSIS package?

Hi all,

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.
0
dafeizhu
Asked:
dafeizhu
  • 3
  • 3
1 Solution
 
cezarFCommented:
add an Execute SQL task then put

DELETE your_Table_name

in the SQL Statement box. click ok
0
 
dafeizhuAuthor Commented:
Glad for the fast response!
0
 
dafeizhuAuthor Commented:
Hi cezarf,
One more question. After i execute this package, the fields will show #DELETE. I need to refresh manually to see the new data. How is it possible to let it refresh automatically?
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
cezarFCommented:
where do you see that and from where do you run the package?
0
 
dafeizhuAuthor Commented:
I saw that in my Access database. I need to press F5 for the newly inserted data to appear.
0
 
cezarFCommented:
sorry, but i have no idea how to make it auto refresh.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now