Solved

How to refresh the destination table when executing SSIS package?

Posted on 2007-11-16
7
498 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

776 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