Update one table to another table using DTS in SQL
I have two databases with the same tables; one in the DMZ and one behind a firewall. I want to update data from either database based on their timestamp. Example:
Update VolunteerInfo table with ImportVolunteerInfo table via DTS package to schedule nightly run. The glue is an ID field being the same in both tables.