Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1394
  • 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
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

 
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

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

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