How to refresh Access database using SSIS?

• woshidafeizhu

  SSC Enthusiast

  Points: 188

  More actions

  November 20, 2007 at 10:42 pm

  #176925

  Hi all,

  I wanted to clear all contents in my Access table and insert new records. I am currently using a variable Delete From Tablename. However, the Access tables will show #Deleted and i need to refresh the table to view the updated records. Are there any ways for me to refresh the table after the updating automatically?

  Thks in advance

• Dave Balsillie

  SSCertifiable

  Points: 5589

  More actions

  November 22, 2007 at 9:02 am

  #753432

  I'm assuming you are using the standard MS Access table view. That's just the standard behavior of Access. (Nothing to do with SSIS.)

  Close / open the table again.