Solved

How to refresh the destination table when executing SSIS package?

Posted on 2007-11-16
7
518 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

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.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

724 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