Home Forums SQL Server 2005 SQL Server 2005 Integration Services Stopping an SSIS Package on Data Flow Fail RE: Stopping an SSIS Package on Data Flow Fail

  • April 30, 2014 at 5:58 am

    #1709791

    nick.latocha (4/30/2014)

    I have an SSIS package with 5 separate data flow tasks. They are not linked and run in parallel. I;m trying to figure out how to stop the other data flow tasks when one task fails. Anyone got any idea?

    I tried setting Max Fails etc but doesn't seem to stop the other tasks.

    Try to add a follow-up task (could be a script task or a ole command task that issues a SQL RAISERROR stmt). Connect your 5 parallel tasks to this new task but only upon failure.