Post reply

Task Dependancy on Concurrent Tasks

  • August 28, 2003 at 5:47 am

    #106027

    Can anyone help with the following please?

    I have the following 4 tasks:

    1) Download a CSV via FTP

    2) Update a flag in a table

    3) Update all records in another table

    4) Use Bulk Insert to insert all records from the downloaded CSV into a table

    I wish to run task 2 followed by task 3 while task 1 is running, and then one all three tasks are complete, execute task 4.

    Currently if either task 1, OR tasks 2 and 3 complete, task 4 is fired.. and this usually amounts to doing the bulk insert based on a file that is not yet present on the filesystem.

    I know that programmatically it's possible to setup this dependancy, but I'm new to DTS and don't really fancy getting into the nitty gritty just yet. Is there any way I can accomplish these requirements without resorting to programming?

    Thanks

    Mark

  • August 28, 2003 at 6:49 am

    #471786

    Set up 'On Success' workflow from step 2 to step 3 to step 4. Also add 'On Succes' from step 1 to step 4.

    Having two 'On Success' constraints on Step 4 works like an AND operation. This means that Step 4 will wait until both Step 1 AND Step 3 have completed.

    Also, on the Package Properties page, make sure you have the 'Maximum number of tasks executed in parallel' option set to a number greater than one.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • August 28, 2003 at 6:56 am

    #471794

    Hi Phill, thanks for your reply. What you describe is exactly as I have it setup now (4 tasks can be executed in parallel), but it seems to be performing a logical OR. Once either task 1 or 3 completes it fires task 4.

    Is there any set of cicumstances which would override the AND you mentioned?

    Cheers

    Mark

  • August 28, 2003 at 7:21 am

    #471806

    Are you sure you have 'On Success' not 'On Completion'?

    With On Success it will wait for both tasks.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply