locked
Repeatability RRS feed

  • Question

  • Hello,

    I noticed that when using SqlSliceIdentifierColumnName or the sqlWriterCleanupScript the delete and the insert are seperated transactions.

    What I mean is that when you run / rerun a slice and there is an error with the copy/ insert.
    The delete part will be executed and you will receive the message that the Activity failed.

    Is this expected behavior? For me it is logical that when the activity fails, no part of the activity is executed. (No delete, no insert)

    Kr,

    Florian

    Monday, November 16, 2015 10:19 AM

All replies

  • Hi Florian,

    Only on re-runs we first execute sqlWriterCleanupScript followed by the copy operation i.e. insert. The copy activity aims to provide data consistency when it has successfully completed.

    Can you kindly help clarify your question here?

    Thanks, Harish

    Tuesday, March 8, 2016 11:58 PM
  • Hello,

    It has been a while since I tested this.

    What I encountered was that when I reran a slice, the cleanupscript succeeds but the copy operation fails.
    This resulted in data being truncated from my table. Without new data being inserted.

    I would expect this transaction (the delete part) to be rolled back when the copy activity fails.
    Is this intended that it is not rolled back?

    I hope this clarifies the question

    Kind regards,

    Florian

    Wednesday, April 20, 2016 3:52 PM