Solved

How to refresh the destination table when executing SSIS package?

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

863 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now