Hi,
I want to select data from one sql server and insert them into another, then
delete the data from first server. But I want to do it in a transaction so
that if the delete fails, the insert can be rolled back. How can I have such
transaction in a DTS packages?
Any help would be greatly appreciated.
Leila

You can use 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)
(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
http://www.sqlis.com

"Leila" <Leilas (AT) hotpop (DOT) com> wrote

shooma mitonid kkoleh DTS package raa bezarid toyeh transaction.

Reza
"Leila" <Leilas (AT) hotpop (DOT) com> wrote