step is on completion, job shows failure | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

step is on completion, job shows failure

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)?
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.
]]>