Post reply

Failure Workflow Does Not Fire

  • April 16, 2007 at 1:39 pm

    #177357

    Hello,

    I have a SQL Server 2000 DTS package in which the first step executes a batch file. The batch file contains FTP commands that log into an FTP server, and pull down whatever file is there.

    I set up a failure workflow to send an email if the step fails. When I have a SQL Server job run this package, and there is no file to dowload, the whole package fails without the failure workflow result firing.

    For the step (DTSStep_DTSCreateProcessTask_1), I have the 'FailPackageOnError' property set to -1. In the package properties, I have the check box for 'Fail Package on First Error' cleared.

    What do I need to do so that the failure workflow occurs when the step fails?

    Thank you for your help!

    cdun2

  • April 16, 2007 at 2:14 pm

    #700780

    Again, never mind. The problem turned out to be a property of the workflow:

    1) You may have the package option "Fail package on first error" checked.

    Right-click on the designer surface, choose Package Properties and click on

    the Logging tab. Make sure the option if off.

    2) You may have the step property "Fail package on step failure" checked. To find out, right-click the task, choose Workflow, then choose Workflow

    Properties, and click the Options tab. You need to make sure the option is

    turned off.

  • April 17, 2007 at 3:03 pm

    #701027

    I believe that step is not failing even if the file is not there, i have came across times when the steps should fail but instead they complete without doing anything and without error.

    Second possibility is it may be messing up withFTP

    Best way is attach a On_Success step also to your step and see if  it will trigger On_success when you are expecting on_failure. 

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

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