Post reply

SSIS Package not following error path

  • March 19, 2012 at 10:17 am

    #149864

    Hi,

    I've got a Warehouse package which has a large number of SSIS packages.

    Some of the SSIS packages are reused multiple times, so we have broker packages that repeatedly call the underlying packages.

    All of this is working fine, but in the top level I was trying to set up an email alert if the load failed.

    The strange part is that SSIS is not following the error path, and the package simply stops. The attached screenshot shows an example of the error path not being followed.

    I have set all of the individual SSIS packages so that FailParentOnFailure is set to True.

    I am missing something?

    Many thanks,

    Graham

  • June 19, 2012 at 4:43 am

    #1502705

    Hi,

    I am still having this problem and would appreciate any suggestions on how to resolve it.

    When my SSIS package calls a SQL Task (which calls a stored procedure which I have placed a RAISERROR in) the SSIS package correctly errors but the data flow doesn't progress down the error flow.

    Is there a setting for SSIS that someone could have set which would cause this behaviour?

    Thanks in advance.

    Graham

  • June 19, 2012 at 8:16 pm

    #1503195

    Hi GRussell31

    I can't explains why your data flow is not following the error path, I can suggest the OnError event at Package level? you can set it up at the Event Handler tab in your BIDS IDE (see picture). The OnError event supports the Send Mail Task, you can give it a try, I know the OnError event is triggered anytime your package breaks with an error like the one you attached, it also seems the OnError event will be easier to implement.

    Let us know how it goes,

    Cheers,

    Hope this helps,
    Rock from VbCity

  • June 20, 2012 at 3:45 am

    #1503293

    Hi,

    Thank you for your reply.

    You are correct that implementing the email via the Event Handler works correctly (and so I've implemented that approach).

    I have no idea why the error path doesn't seem to work though.

    Thank you for your help.

    Regards,

    Graham

  • June 20, 2012 at 9:16 am

    #1503524

    For the item that failed - what is its "on failure fail parent" and "on failure fail package" (they are something like that) properties.

    I would turn these both to false - that way the package wont fail and will continue down the failure route.

    I know you said you are doing it on the onerror way now - but just incase...

  • June 20, 2012 at 9:40 am

    #1503556

    Hi,

    The FailPackageOnFailure is greyed out (but showing False) at a package level and FailParentOnFailure is also showing False.

    I have a feeling some of the child packages may have the FailParentOnFailure flag set to True though.

    Regards,

    Graham

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

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