Re: DTS Task Flow question

#1

And here you go

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

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Rolo Tomassie" <rolo_tomassie2002 (AT) yahoo (DOT) com> wrote

Quote:

I'm working on a DTS pkg which needs to take one action upon task success
or
take another action upon failure. At some point in the pkg, whether via
success or failure, I want the all flow to join back into a single path.
For example, given the following scenaro...

(start)

(start.failure) (start.success)

(final)

Assume each () represents an ActiveX Script task, starting with (start).
If
(start) succeeds, the the (start.success) task
is executed, if it fails the the (start.failure) task is executed. Upon
completion of either the failure or success task, I want
(final) to be executed. My problem is that (final) is never executed if
more than 1 path flows into it (rather like a boolean circuit instead of
an
execution flow-chart).

See attached dts pkg for a simple example (pkg password is test).

Can someone explain why this is happening and point me in the correct
direction to get around it. I don't want to duplicate (final) for each
possible success and failure case.

Specifically, I am dealing with importing text files into a database and
the
files 1) may or may not exist and 2) may or may not have data. Regardless
of the files, there is logic in (final) and many other tasks further down
the path that needs to be executed.

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: DTS Task Flow question

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: DTS Task Flow question - 09-04-2003 , 01:24 AM