Post reply

SSIS Package failure rollover and email notification

  • January 22, 2014 at 9:22 am

    #287544

    Hello,

    I would like to configure the SSIS package to rollover/cancel the actions if any any point it fails i.e. I am planning to copy data from different tables and if any fail table copy event I would like to rollback the copying and cancel the job and send the email notification to the user that it fails.

    What's best way to achieve this?

    Thanks,

    Yash

  • January 22, 2014 at 9:25 am

    #1682480

    Yash

    Put all the tasks in question into a Sequence container and set the TransctionOption property to Required.

    John

  • January 22, 2014 at 9:26 am

    #1682481

    Thanks John for the quick reply, I am guessing that's on the Job Scheduler at the SQL agent area?

    Yash

  • January 22, 2014 at 9:33 am

    #1682485

    Yash

    No, it's in the package. You need to open the .dtsx file in BIDS and redesign it.

    John

  • January 22, 2014 at 9:43 am

    #1682491

    I am little families with BIDS, do you have any instruction/step by step guide for this?

    Thanks,

    Yash

  • January 22, 2014 at 9:49 am

    #1682495

    Yash

    It's not easy to condense into a few sentences if you've never designed or edited a package before. Is your code all under source control? Is the person who wrote the package still around to help you? You may wish to work your way through this stairway[/url] on SSIS.

    John

  • January 22, 2014 at 10:04 am

    #1682504

    I was the one who created the SSIS package and now learning to customize it by rollover at the fail condition and send email the results. I will definitely look into the link you provided and appreciate your effort to guide me to the correct direction.

    Thanks,

    Yash

Viewing 7 posts - 1 through 6 (of 6 total)

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