Re: AND or OR condition?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: David N. (huongdat_at_comcast.net)
Date: 05/05/04 

Date: Wed, 5 May 2004 10:18:19 -0700

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: Problem with Windows 2000 Advanced Server running cluster service
    ... hotfixes mentioned in these articles are Post SP4 fixes. ... Windows 2000 MCSE + MCDBA ... Windows NT/2000/2003 Cluster Technologies ... 1_The secuity package negotiate generated an exception. ...
    (microsoft.public.windows.server.clustering)
  • RE: Server restarted alone!!
    ... Microsoft Product Support Services to further troubleshoot this issue. ... hotfixes mentioned in these articles are Post SP4 fixes. ... Windows NT/2000/2003 Cluster Technologies ... 1_The secuity package negotiate generated an exception. ...
    (microsoft.public.win2000.advanced_server)
  • Fun with Tasking
    ... Below is sample code I made representing something I wanted to do with ... this, as I mentioned, "exec" is representative of a family of several ... package Convert is new System.Address_To_Access_Conversions ... end loop; ...
    (comp.lang.ada)
  • Re: Oracle procedure raises exception but looks to be successful from DBI
    ... I sort if expected that for the exec it is usualy only used withing SP ... Either the use who is calling the SP dose not have execute permission for the package or something in the package or the present state of the package is stopping you from executing it. ... The fact that DBD is returning the error from Oracle usually means that DBD is running correctly. ...
    (perl.dbi.users)
  • Re: Fancy articles in LaTeX
    ... I am a huge fan of LaTeX and love learning about it. ... These two articles, in PDF form, as well ... Another package that does something similar also exists: ... However, as stated on CTAN, this package is rather out-dated. ...
    (comp.text.tex)