Refresh Data

• Victor-230790

  Mr or Mrs. 500

  Points: 524

  More actions

  May 12, 2005 at 9:58 am

  #186033

  I want refresh data de SQL Server, every certain time at night, but I want that it does only, automaticy.

  In SQL sentencs or DTS

  What I can do. Thanks

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  May 12, 2005 at 10:02 am

  #558467

  Create a DTS package that imports the data and updates the SQL Server tables, then schedule the package as a SQL Server job that runs nightly.

  Greg

  Greg