Sorry for my previous post in Ita language. I was thinking to be on
another NG...
My problem now is: how to set up a SINGLE transaction for a multiple
step DTS package.
Let's say I have 7 table deleting and data-pumping packages, each of
them being a step in a global package, executing other sql and sp
commands between steps.
My question is how to make all of it as a single transaction, in order
to have the entire work COMMITED or ROLLEDback.
I tried inserting Begin tran and commit tran sql steps, but commit tran
step fails as "no begin tran had been issued".
Any suggestion?
Thanks
Alberto
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG