• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1395
  • 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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

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