March 11th, 2004, 02:42 PM
|
|
Registered User
|
|
Join Date: Mar 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Determing updated records via Timed DTS Package
Hi,
How can you determine if a record has been updated? (or inserted/deleted). A trigger does this automatically by design but we need to run this only periodically, say every 15 or 20 minutes. I'm learning about DTS, packages, and scheduling which is great but I am unsure how to identify which records have been altered in the time period between runs so only those records get processed.
Thanks
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
