Solved

How to refresh the destination table when executing SSIS package?

Posted on 2007-11-16
7
511 Views
Last Modified: 2013-11-30
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
Comment
Question by:dafeizhu
  • 3
  • 2
7 Comments
 
LVL 18

Expert Comment

by:Yveau
ID: 20305143
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
 

Author Comment

by:dafeizhu
ID: 20307016
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
 
LVL 18

Expert Comment

by:Yveau
ID: 20307038
... 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
 

Author Comment

by:dafeizhu
ID: 20326409
After i drop the table, I have problems creating the table again. Can advise on this?
Thks
0
 
LVL 18

Accepted Solution

by:
Yveau earned 50 total points
ID: 20330338
Something similar to this:

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

Open in new window

0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Omit After Update event 5 17
Access #Deleted data 20 43
T-SQL: I need to add an index on a field 5 27
Need SQL Update 2 9
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

726 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