Home Forums SQL Server 2005 SQL Server 2005 Integration Services SSIS Package not failing? RE: SSIS Package not failing?

  • March 31, 2014 at 2:16 pm

    #1701790

    david.ostrander (3/31/2014)

    Hello -

    My SQL Server Agent shows successful completion of SSIS job but messages in Log File view shows that there was an error. How can I get the Agent to fail if there was an error or a failed to execute in the SSIS package?

    See attached pic for what I am seeing.

    Thank you,

    David

    As far as I can tell, there is something wrong in the logic, looks like a primary key conflict is failing the package. As any further comments would be pure speculations, can you share some more information here? 😎