Results 1 to 2 of 2

Thread: DTS question

  1. #1
    Join Date
    Sep 2003
    Posts
    212

    Unanswered: DTS question

    I have package that Extracts a zip file. Now the zip file is updated bi-weekly between 9-11am. So the DTS package is schedule to run at 9am. Once the zip is extracted it is renamed (different from original).

    But before extraction, i have a few tasks that check whether the zip exists or not.

    PROBLEM: If the zip new file exists at 9am, it's all good and the package will be successful. The problem i'm facing is, say the zip file is not available at 9am, I want the package to check if the file exists - every x minutes till 11am.

    This polling for the file is creating a alot of problems for me.

    Any help/advise would be appreciated.

    Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    Germany
    Posts
    63

    Re: DTS question

    Hello!

    I assume that you have an ActiveXTask as one of the first steps in that DTS Package, that checks the existence of the ZIP-File.

    If you make this task loop until it finds the ZIP-File, that would be the first step. In this loop there should be a command that calls a VBScript with something like "WScript.Sleep 600000" (which should stop the script from continuing for 10 minutes!).

    Hope that gave you some hints!

    Greetings,

    Carsten

    Originally posted by vmlal
    I have package that Extracts a zip file. Now the zip file is updated bi-weekly between 9-11am. So the DTS package is schedule to run at 9am. Once the zip is extracted it is renamed (different from original).

    But before extraction, i have a few tasks that check whether the zip exists or not.

    PROBLEM: If the zip new file exists at 9am, it's all good and the package will be successful. The problem i'm facing is, say the zip file is not available at 9am, I want the package to check if the file exists - every x minutes till 11am.

    This polling for the file is creating a alot of problems for me.

    Any help/advise would be appreciated.

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •