none
ssis - data getting commit on failure as well RRS feed

  • Question

  • If the ssis jobs fail,  i see still some data getting committed. During debug ssis lets you see how many data it has moved in real time. No if the job fails while the latest nos of rows processed is x then i see x records in target table.
    Friday, December 15, 2017 1:47 AM

All replies

  • Yep

    If you don't want it commited, you'd have to have a transaction configured

    Friday, December 15, 2017 1:59 AM
  • Hi SayedMohammad,

    You need to configure a package to use transactions.

    See: Integration Services Transactions

    Best Regards,

    Pirlo Zhang


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, December 15, 2017 7:04 AM
    Moderator