Solved

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

Posted on 2007-11-15
6
1,386 Views
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.
0
Comment
Question by:dafeizhu
  • 3
  • 3
6 Comments
 
LVL 14

Accepted Solution

by:
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
0
 

Author Closing Comment

by:dafeizhu
ID: 31409509
Glad for the fast response!
0
 

Author Comment

by:dafeizhu
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?
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 14

Expert Comment

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

Author Comment

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

Expert Comment

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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

778 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