Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    England
    Posts
    15

    Unanswered: Checking for an instance of DTS packages

    Does anyone know of a way to check for an instance of a DTS package?

    E.g. I have a package called 'Package1' that is currently running.
    Someone else attempts to run the package and before they can i want to check if an instance of 'Package1' already exists, if it does then the package will not run.

    possible or pipedream?

    cheers

    tom

  2. #2
    Join Date
    Apr 2004
    Posts
    64
    Identifying if an instance of your package is already running via the DTS object is not an easy or straightfoward issue. But you could easily get round it by using a global variable in your package. Assign it a value as soon as the package kicks off, hold the value and either kill the variable or assign it another variable when the package has finished running. Test the global variable and thereby decide whether to continue running the package or not.

    I however admit I have never actually had to do this.

    http://msdn.microsoft.com/library/de...papps_64z0.asp
    Last edited by TechnicalAli; 06-28-04 at 13:23.

  3. #3
    Join Date
    Mar 2004
    Location
    England
    Posts
    15
    Yes i had thought of a similar idea of just setting an in-use flag stored in an .ini file or something.

    just wondered if there was a slick way to do it that all.

    Thanks for the advice, mucho appreciated.

    t

Posting Permissions

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