• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 534
  • Last Modified:

How to refresh the destination table when executing SSIS package?

Hi all,

I wanted to clear all the fields in my destination table in Access. However, I must click refresh manually to see the newly inserted fields. How is it possible to let it refresh whenever the package is executed?

Thks
0
dafeizhu
Asked:
dafeizhu
  • 3
  • 2
1 Solution
 
YveauCommented:
as far as I know, there is no automatic refresh functionality in Access.
So ... you can't ... sorry to bring you the bad news.

Hope this helps ...
0
 
dafeizhuAuthor Commented:
Since my objective is to clear all contents in the Access table before importing data into it,
do you think deleting the whole table will help? In my current project, I am deleting the records in the table only.
0
 
YveauCommented:
... that is a bit over the top. Then you have to recreate the table again ... and I still think that there will be no auto refresh ... I'm not sure, you should give it a try.
But might it do the auto refresh, it's a small price to pay when only recreating the table does the trick for you.

Hope this helps ...
0
 
dafeizhuAuthor Commented:
After i drop the table, I have problems creating the table again. Can advise on this?
Thks
0
 
YveauCommented:
Something similar to this:

Hope this helps ...
create table Yveau (Column1 integer, Column2 varchar(10))

Open in new window

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

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

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