How to: Rollback all steps on failure of any step

#1

I have a DTS package that reads from a staging table. A series of SQL tasks
update a number of tables in the database. The last step truncates the
staging table, making it ready for new records. If this step (the truncate)
fails I want all the updates performed by the preceeding SQL tasks rolled
back.

Is this possible?

Thanks!

Ric

#2

This might help you then

http://groups.google.com/group/micro...04ff5f36c75773

--

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

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

Quote:

I have a DTS package that reads from a staging table. A series of SQL
tasks
update a number of tables in the database. The last step truncates the
staging table, making it ready for new records. If this step (the
truncate)
fails I want all the updates performed by the preceeding SQL tasks rolled
back.

Is this possible?

Thanks!

Ric

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to: Rollback all steps on failure of any step

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

How to: Rollback all steps on failure of any step - 04-26-2006 , 04:07 PM

Re: How to: Rollback all steps on failure of any step - 04-26-2006 , 04:39 PM