Post reply

SSIS Package development functionality

  • August 2, 2015 at 2:40 am

    #149003

    Hi ,

    I am working on SSIS package where client wanted to have below functionality in that package

    1. Exception handling

    Notification will be sent to ETL support team in case of any failures

    2. Restart requirement

    The ETL process can be restarted in case of failure

    3. Data Recovery

    Data can be reloaded if data is deleted from Spectrum database

    For the first point I have created a SQL agent database mail profile and firing a mail to respective team member on package failure

    I have placed the execute sql task on failure under the Event handler tag

    for second point I have implemented the checkpoint in that package

    for third I Have enable the Transaction property so if any of the task failed It will be rollback

    Can you please share your views whether I am using correct approach or not

    Thanks in Advance

    Vipin Jha

  • August 2, 2015 at 11:59 am

    #1816688

    The 3rd point sounds like they want to keep the original source files forever.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • August 2, 2015 at 3:49 pm

    #1816703

    Also, on #1, I'd point out that sending an email upon failure is a notification, not exception handling. If I wrote a spec and asked for exception handling, I would intend for something more robust.

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices

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

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