You have to use workflow scripts to alter the precedence constraints.
Have a look at this tutorial.
http://www.sqldts.com/default.aspx?218
Thanks
Phillip Carter
Ph: +61 3 9235 1691
-----Original Message-----
From: Juan Vera
[mailto:mssqldba-ezmlmshield-x14922405.[Email address protected]
Sent: Friday, 29 April 2005 5:52 AM
To: LazyDBA Discussion
Subject: DTS Packages & Workflow
I am writing some workflow logic into a DTS package and am frustrated by
a problem:
If I want:
step 1 -> step 2 on success
step 1 -> step 3 on failure
step 2 -> step 4 on success
step 3 -> step 4 on success
but I <know> steps 2 & 3 never run on the same execution, since 3 is an
alternative to recover in case of a failure in 2, I need the DTS to
understand a logical OR, i.e. run step 4 if either 2 or 3 succeed.
However, there seems to be no logical OR available for aggregating
workflow conditions in the DTS, so the "recommendation" is to copy/paste
step 4 !?!?! - Now, this stinks because obviously if the job has several
steps then the number of copies grows rapidly, and as database people I
don't think I need to explain to this group how all errors start from
information duplication / denormalization, never more so than in
processes...
does anyone know how to get the DTS to do a logical OR, so I can avoid
having to copy & paste the entire logic tree following from step 4 in
this scenario?
TIA
Juan Cristian
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
IMPORTANT DISCLAIMER - THIS MAY AFFECT YOUR LEGAL RIGHTS:
Because this document has been prepared without consideration of any
specific clients investment objectives, financial situation or needs,
a Bell Potter Securities Limited investment adviser should be
consulted before any investment decision is made.
While this document is based on the information from sources which
are considered reliable, Bell Potter Securities Limited, its directors,
employees and consultants do not represent, warrant or guarantee,
expressly or impliedly, that the information contained in this document
is complete or accurate.
Nor does Bell Potter Securities Limited accept any responsibility to
inform you of any matter that subsequently comes to its notice, which
may affect any of the information contained in this document.
This document is a private communication to clients and is not intended
for public circulation or for the use of any third party, without the
prior approval of Bell Potter Securities.
Disclosure of Interest: Bell Potter Securities Limited receives commission
from dealing in securities and its authorised representatives, or introducers
of business, may directly share in this commission. Bell Potter Securities
and its associates may hold shares in the companies recommended.
Bell Potter Securities Limited ABN 25 006 390 772 AFS Licence No. 243480
MS Sql Server LazyDBA home page