ETL - cancel changes and going back to a previous state



Hi there,

I would like to know if this is a usual practice to having an ETL able to
cancel (rollback) the move of data that has been done into a destination.

In other words, after having inserted data into a destination, can we go
back to a previous state?
Is that common to do that? How to do that? What do we need to consider
before implementing such a feature? What tools/solutions are available to
activate this feature?

I personaly use MS SSIS as an ETL tool

Thanks,

Christophe


.



Relevant Pages

  • Re: file copy/paste cancel
    ... cancelling it at 50% would still show a 100MB file in the destination but it would only contain valid data in the first 50MB. ... It's likely that it shows the filename, then calls CopyFileand changes the progress only when the copy is completed, so you really only get the chance to cancel between files, not during files. ... You have a file which already exists in the destination folder and you're ...
    (microsoft.public.windowsce.platbuilder)
  • Re: My HP49G+ with 2.09 ROM does not factor (2^67-1)?????
    ... of the HP-48G built-in CHOOSE engine. ... and I found myself more than once trying to cancel the search. ... but I included the 'cancel search' feature in the replacement browser ... I don't quite fathom why any command limits itself ...
    (comp.sys.hp48)
  • Re: BWAHAHAHA!!! More KDE fuckwittery
    ... >> copy if a duplicate file exists in the destination and you select cancel. ... Not a bug. ... Cancel is supposed to camcel the entire operation. ...
    (alt.os.linux)
  • Re: Copying a large file from one machine to another in 2000 Prof
    ... > 2.Copy it to machine B by mapping any share folder. ... Start Copying the same file from Machine A to B in the ... If you cancel the copy I'm not surprised the file ... It's not a feature. ...
    (microsoft.public.win2000.general)
  • Customised error boxes in RO 3.1
    ... Cancel buttons with one's own legends was a feature only ... Derek Haslam dhaslam atte boulsworth dotcodotuk ...
    (comp.sys.acorn.apps)