MS SQL Server DTS - DTS rollback ?

Author

DTS rollback ?

Franky

2005-07-23, 3:23 am

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

Allan Mitchell

2005-07-23, 3:23 am

Yep you certainly can do this

if you start here

http://msdn.microsoft.com/library/d...ddf_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@discussions.microsoft.com> wrote in message
news:605710C2-42F6-41CE-AC9C- 10CF1C4B98E3@microso
ft.com...
> 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

Sponsored Links