Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1392
  • 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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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