Post reply

Transactions in SSIS

  • October 20, 2008 at 2:21 am

    #200145

    Hi,

    How do i ascertain a ROLLBACK TRANSACTION in case any error happens in 'any' of the control flow components? :unsure:

  • October 20, 2008 at 4:48 am

    #887049

    On the package properties, set the transaction level to required.

    Unless you have changed the transaction level of any of the components you have added, they will all have defaulted to joining any running transaction so your package should roll back everything in the event of an error.

    Remember to examine everything carefully. There are oledb drivers that do not support distributed transactions.

  • October 20, 2008 at 8:13 am

    #887135

    We do have the trasaction levels of the components used. yet i don see the rollback happening in the case of a exception in the package.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply