Hi All,

I'm trying to write an Active X task that waits for 2 parallel data pump
tasks or excute SQL task to finish before it goes to the next step. Just
wonder if there's any site I can "copy" :-) the code from? Being new to SQL
server and all, just wonder if there's any books you would recommend for the
scripting. I have attended the DTS training but it doesn't seem to tell you
about the codes.

Thanks in advance for your help!

In message <D3DEFEB3-BD27-4FD2-B60B-40C6C9793110 (AT) microsoft (DOT) com>, Dave
Wong <Dave (AT) Wong (DOT) ?.microsoft.com.invalid> writes
You can do this simply with workflow constraints. Have the task that
must wait for the any preceding tasks linked by some workflow. All
workflow constraints must be satisfied for a task to execute, think of
AND logic not OR logic when looking at workflow.

There are several books out now on DTS, and plenty of info on websites.
Try www.sqldts.com, list of books under Resources section.


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

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

Thanks Darren! I came up with a method which involves GV, but I think there
is a smarter way to read the result of the datapumps and use that as a
condition. Thanks again.


"Darren Green" wrote: