Re: RollBack Transactions in the DTS

#1

You can do this with a package transaction. Please read the "Incorporating
Transactions in a DTS Package" section of Books Online-

(http://msdn.microsoft.com/library/de...-us/dtssql/dts
_addf_tx_2n8l.asp?frame=true)

Or

http://tinyurl.com/3zstq

Or

(mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL% 20Server\80\Tools\Books\dt
ssql.chm::/dts_addf_tx_2n8l.htm)

--
Darren Green
http://www.sqldts.com

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

Quote:

Hi guys,
I am using SQL server 200 ,DTS
package and in this package i am using
many tasks.
i want to roll back the whole
transaction when an error occurs in the
package how shall i do this?
for example there r 3 tasks in my
package and first one is to dump data
into TABLEA and after this is completed
data is dumped into TABLEB and after
this task is completed data is dumped
into TABLEC and in this process if an
error occurs while dumping data into
TABLEC then i want to rollback the
whole transaction i mean data dumping
into TABLEA and also TABLEB.how shall i
achieve this?

--
Thanks
Akber.

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

Re: RollBack Transactions in the DTS

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

Re: RollBack Transactions in the DTS - 08-09-2004 , 08:15 AM