Post reply

REPORT ON ROLLBACK

  • October 19, 2010 at 2:37 am

    #230634

    Hi guys

    I have a stored procedure within SSIS which inserts updates and deletes, because sometimes the data comes in the wrong format the package fails so i have implemented a try catch and rollback code, is there a way to send an email or write a log file to make the user aware that the data hasn't not been committed.

    cheers

  • October 19, 2010 at 4:24 am

    #1238926

    OK here I go,

    Below is what I understand...

    Step 1: Set FailPackageOnFailure to True.

    Step 2: Design event handler - OnTaskFailed and incorporate it with a Send Mail Task for the package element that causes rollback.

    Step 3: Enhance the design so as to meet your need!!!:-):-):-)

    Raunak J

  • October 19, 2010 at 5:54 am

    #1238964

    Could you please expand on this as iam new to ssis

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

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