[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now


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

Posted on 2007-11-15
Medium Priority
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 14

Accepted Solution

cezarF earned 200 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?
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

650 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