I have source server and destination server, i have insert the data from source to destination, but before that i have to delete the records if any in destination - (DTS)
A:
Create an Execute SQL task in the correct sequence of your package and call the following code to delete the rows
TRUNCATE TABLE tablename
Refer MSDN link for more details
InSane
2010-09-16 10:03:40
Hey i know how to delete records in db, i asking what are all the steps in DTS
Kishh
2010-09-16 10:04:48
@Edited the answer - Hope this helps! You can basically execute the statement i had entered earlier using a Execute SQL task - in the correct sequence
InSane
2010-09-16 10:14:36