Hi all,


I have created a DTS Job which Appened Destination
Table ABC from Source Table DEF every 3 hours.

How how do i truncate Data in Source Table DEF so tht
it does not append duplicate records.
and wht time i should schedule it
It very urgent
TIA
ADIL


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
MS Sql Server LazyDBA home page