Hello,

I have a DTS package to replicate data from one site to another. The first
step in the DTS is to delete data in the Destination, then it inserts the
source data into the destination. Sometimes, the first step ran OK but the
second step failed, I was ended up with empty tables in the destination. Is
it possible to have a roll back in the DTS package or put two steps into a
single transactions?

Thanks in Advance

Yep you certainly can do this

if you start here

http://msdn.microsoft.com/library/de...df_tx_2n8l.asp

then look in the tree to the left you will find all you need to know

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Franky" <Franky (AT) discussions (DOT) microsoft.com> wrote