Post reply

failure of a data flow task causes the job to fail

  • January 25, 2018 at 8:37 am

    #343429

    Hello

    I have a fairly simply package
    In this I have a data flow task that takes XML data and loads this into a set of tables

    Problem is, if the load fails, the job fails
    What I really want is a mail to go out stating that there's been a failure and the job suceeds

    In simple terms, the task goes either red or green and I use presedance flows to send a message or carry on with other stuff
    BUT, if it does go red, it send the message and fails the job

    I feel there's a setting out there to ignore the failure (for job purposes) yet see the failure for mailing purposes

    Any thoughts?

    Thanks

    Damian.

    - Damian

  • January 25, 2018 at 8:45 am

    #1977358

    Damian

    Does this help?

    John

  • January 25, 2018 at 8:56 am

    #1977364

    It does and I think it's a mix of OnError and (something I've just stumbled across) ForceExecutionResult

    ForceExecutionResult = Success looks to ensure that the task doesn't return a failure - so it's now green regardless!
    OnError as a task event handler is now looking to do the trick
    Under OnError, just knocked a script together that updates a variable
    Now using the variable to in a presedence expression

    Thanks

    Damian.

    - Damian

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

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