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

Posted on 2007-11-15
Last Modified: 2013-11-30
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.
Question by:dafeizhu
  • 3
  • 3
LVL 14

Accepted Solution

cezarF earned 50 total points
ID: 20296734
add an Execute SQL task then put

DELETE your_Table_name

in the SQL Statement box. click ok

Author Closing Comment

ID: 31409509
Glad for the fast response!

Author Comment

ID: 20296854
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?
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

LVL 14

Expert Comment

ID: 20296881
where do you see that and from where do you run the package?

Author Comment

ID: 20296914
I saw that in my Access database. I need to press F5 for the newly inserted data to appear.
LVL 14

Expert Comment

ID: 20296976
sorry, but i have no idea how to make it auto refresh.

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now