SQL Server Performance

step is on completion, job shows failure

Discussion in 'SQL Server DTS-Related Questions' started by cronid, Oct 31, 2006.

  1. cronid New Member

    I have a package where the first step archives a file if it is present. Most times it should not be present, so I have set the workflow for the next step to be on completion. This works fine for the package, the subsequent steps are always executed as I intended. Unfortunately, the job shows as a failure most days when the file is not present.

    Is there a way to set up the job (or package) so that the results of this first step (failure or success) do not impact the job status (failure or success)?

  2. satya Moderator

    Enable the logging for this package and see what is happening as a whole when it is finishing the package.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page