Hopefully this posts...

I have a DTS Package that is pulling in a text file, importing the records into a temp table. While in the temp table, 2 queries are ran against the data to move any "incomplete" or "dup" records into 2 separate "user" tables...

Then run a count statement against the "dup" temp table, if there records it should follow "path" 1, if there aren't any records then it should follow "path" 2, which starts another count statement against the "incomplete" table and depending on that count follows either "path" 3 or "path" 4....

However, I need for "path" 1 to end back up at the count statement of the "incomplete" table and then follow that "path" through completion

Will this run?? Or will I have to put an ActiveX Control to "reenabled path" 2 before leaving "path" 1??

In article <B12325D7-08BB-461D-8501-24C2B9AF2B46 (AT) microsoft (DOT) com>, Toby
<anonymous (AT) discussions (DOT) microsoft.com> writes

Workflow scripts are the thing to use when choosing a path to follow. To
join up again you can do it by skipping, small amounts of messy code-

Skip the execution of an individual Task
(http://www.sqldts.com/default.aspx?214)

or lots of messy code-

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


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org