Re: Cancelling a dts package

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 10/07/03 

Date: Tue, 7 Oct 2003 18:16:31 +0100

If you don't explicitly initiate transactions from a DTS package, when you
cancel it, it will finish the current step and exit. It will not rollback. 

-- 
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Dave Brooks" <dbrooks@neca.org> wrote in message
news:%23V%23F8xOjDHA.2636@TK2MSFTNGP11.phx.gbl...
Using dts export/import to copy all objects, if the job is cancelled
does it rollback what it did???
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • dts
    ... If you cancel a dts package of a export/import of all tables, ... say 1/2 way complete, does it rollback. ...
    (microsoft.public.sqlserver.security)
  • Re: MSFT Patch mess up my SQL job path
    ... Is it a MSFT Patch you are trying to rollback ... Changes to an existing DTS Package ... > Hi Ryan, ... > I tried to see there is any rollback options there, ...
    (microsoft.public.sqlserver.dts)
  • Re: Service Installer Credentials Dialog
    ... What if the user do not put the correct info? ... The rollback is a Cancel after ... want the installer to allow the user to put in the correct information ... or cancel if they want to back out. ...
    (microsoft.public.dotnet.languages.csharp)
  • 12 million row DTS package Help Reqd
    ... I've just set a DTS package to copy one database from a ... sql7 server to a sql 2000 server. ... I need to cancel the views on 2 ...
    (microsoft.public.sqlserver.dts)
  • Re: How to revert the data by clicking cancel without save data?
    ... > Can anybody provide a sample code for 'cancel' button to rollback the data ... after modified but not going to hit "save"? ... > (Using Tableupdate function) ...
    (microsoft.public.fox.programmer.exchange)
Loading