It depends on how you use the destination table. If you have users
accessing the destination table, you wouldn't normally truncate the
table as it would empty the table.

For truncating the table:

(1) Create a Execute SQL task with the truncate command for the
destination table

(2) Add a workflow object, specify "On Success" of the SQL Task the next
task would be your transfer task.

Hope that helps!!

John

-----Original Message-----
From: Adil Basha [mailto:[Email Address Removed]
Sent: Friday, July 25, 2003 2:50 PM
To: LazyDBA.com Discussion
Subject: DTS Schedule

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

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page