Post reply

Make a DTS Task wait

  • May 20, 2005 at 3:45 am

    #66545

    Hi,

    I have a DTS package that unzips a file and copies some files into the new folder. The problem I have is that the unzip task runs in no time and then it moves on to the next task, however it takes around 30 seconds for the zip program to actually unzip the file and the next task fails because it relies on the zip file being completly unzipped.

    Is there any way to delay the next task? I was going to write an activex script that loops for a while but am not that keen on that idea.

    Thanks

    Jon

  • May 20, 2005 at 8:51 am

    #560228

    You should use completion on you workflow.

    http://www.sqldts.com/default.aspx?287

    Rgds

    JFB

  • May 20, 2005 at 3:25 pm

    #560362

    If you are using the "Execute Process Task" you may be running into an issue where the task was able to start the exe which results in a return code of success and you are off and running (even though the exe is still busy doing it's thing).

    Try adding some checks like a file count in the extract directory.

    Good luck,

    Darrell

  • May 20, 2005 at 4:25 pm

    #560366

    Thanks I figured it out in the end.

    I was using an ActiveX Task with WshShell.Run (strCommand, [intWindowStyle], [bWaitOnReturn]), I just switched on the WaitOnReturn and it works perfectly.

    Thanks for your input.

    Jon

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

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