Re: AND or OR condition?

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 05/05/04 

Date: Wed, 5 May 2004 20:50:31 +0100

Fail package on first error does just that, it fails the package on the
first error within. That is not a task.

To implement a logical OR page 2 should have helped

Multiple Paths in Workflow
(http://www.sqldts.com/default.aspx?218,2) 

-- 
-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
" David N." <huongdat@comcast.net> wrote in message
news:u%23cn4TsMEHA.3016@tk2msftngp13.phx.gbl...
> Thanks Allan,
>
>
> The two articles answer my first question:  the DTS package uses the
logical
> AND, which means that all requirements must be fullfilled in order for the
> step to be executed.  This means that the code in #1 is correct.
>
> However, they did not answer the my second question, which is, how do I
> apply the logical OR?  There is a package property "fail package on first
> error", but I am not so sure if checking that property checkbox would
> guarantee that the Error_Handling step is to be executed on the first
error
> or not.
>
> DQ
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> news:uTTMTSnMEHA.684@TK2MSFTNGP09.phx.gbl...
> > Have a look at this article
> >
> > Introduction to Workflow
> > (http://www.sqldts.com/default.aspx?287)
> >
> > Followed by
> >
> > Multiple Paths in Workflow
> > (http://www.sqldts.com/default.aspx?218)
> >
> > -- 
> >
> > ----------------------------
> >
> > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> > www.SQLDTS.com - The site for all your DTS needs.
> > I support PASS - the definitive, global community
> > for SQL Server professionals - http://www.sqlpass.org
> >
> >
> > " David N." <huongdat@comcast.net> wrote in message
> > news:%234Y$lGkMEHA.340@TK2MSFTNGP11.phx.gbl...
> > >
> > > Hi All,
> > >
> > > I see the following DTS definitions, and they confused me:
> > >
> > > 1.  Step that is executed based on the success of previous STEPS
> > >
> > > <STEP Id="s999">
> > >
> > > <REQUIREMENT TYPE="SUCCESS" STEP="s4A"/>
> > >
> > > <REQUIREMENT TYPE="SUCCESS" STEP="s4B"/>
> > >
> > > <REQUIREMENT TYPE="SUCCESS" STEP="s4C"/>
> > >
> > > <REQUIREMENT TYPE="SUCCESS" STEP="s4C_A"/>
> > >
> > > <REQUIREMENT TYPE="SUCCESS" STEP="s4C_B"/>
> > >
> > > <SQLCMD Id="EndPackage" CONNECTION="DESTINATION" AsRowset="false">
> > >
> > > exec dbo.xxxxx
> > >
> > > </SQLCMD>
> > >
> > > </STEP>
> > >
> > >
> > > 2. Step that is executed based on the failure of previous STEPS
> > >
> > > <STEP Id="ERROR_HANLIND">
> > >
> > > <REQUIREMENT TYPE="FAILURE" STEP="020 "/>
> > >
> > > <REQUIREMENT TYPE="FAILURE" STEP="s1"/>
> > >
> > > <REQUIREMENT TYPE="FAILURE" STEP="010"/>
> > >
> > > <SQLCMD Id="Error_Handling" CONNECTION="CONFIG" AsRowset="false">
> > >
> > > EXEC dbo.xxxxx
> > >
> > > </SQLCMD>
> > >
> > > </STEP>
> > >
> > >
> > >
> > > In my thinking, the author who developed step s999 in #1 must be
> thinking
> > > that it is the AND condition that implied to the requirement.  He
wants
> > all
> > > of those previous steps to be success in order for the step s999 to be
> > > executed.
> > >
> > > In the contract, the author who developed step ERROR_HANLDING must be
> > > thinking that it is the OR condition that implied to the requirement.
> He
> > > wants the ERROR_HANDLING step to be executed if any one of the three
> steps
> > > in the requirement failed.
> > >
> > > My questions are:
> > >
> > > 1.  Which step has the correct requirement?
> > > 2.  If the AND is implied, how do I implement the OR?
> > > 3.  Vise versa, if the OR is implied, how do I implement the AND?
> > >
> > > Thanks in advance...
> > >
> > > Best regards
> > >
> > > David.
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Rows not transferring
    ... Log in as the Account which would be doing the execution if you were a job ... Now manually call the package yourself as the job would. ... fail on first error is set. ...
    (microsoft.public.sqlserver.dts)
  • Re: Main = DTSTaskExecResult_Failure does not raise an error
    ... But the on failure workflow ... I have cleared the ?Fail package on first error? ...
    (microsoft.public.sqlserver.dts)
  • Re: [ANN] FoX - an XML toolkit for Fortran
    ... In contradiction to http://uszla.me.uk/space/software/FoX/compat/, the ... to build the package. ... The first error is ... My opinion is that there is indeed a bug in ifort. ...
    (comp.lang.fortran)
  • Re: Execute Package Task continues after failure
    ... > Set Fail on first error on in the child package. ... This option is on Package ... >> I want the loader package to stop in case of a failure in a package. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS workflow failure
    ... I use simple links, on success and on failure are used in my case, and I set ... "fail package on first error" is true. ... > SUCCESS constraint and it did not succeed. ...
    (microsoft.public.sqlserver.dts)