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

    Unanswered: DTS Global Variables Behaviour with > 1 User

    Hi all

    I have a DTS package that users of the database can run which basically acts like a 'live update' (as the database is based on a values produced from another system) and it takes roughly 30 or so seconds to run...

    The dts package is not going to have a particularly large hit rate but i am interested in knowing what will happen if a user (user 1) attempts to run the package when it is in already in use by another user (user 2) ?

    The dts package is from a sp using the dtsrun utility (passes in global variables).

    I know that a second DTS will start before the first has finished but what i am not sure about is what will happen to the Global Variables when the second DTS package starts - i.e. will starting a second instance of the package with different variables have an effect on the first DTS's global variables while it is running?

    I hope the answer is "No Tom, it work fine!"

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    DTS is a weird beast to describe, because there are so many different contexts. The short answer is that each of the instances of a DTS package will have their own global variables.

    -PatP

  3. #3
    Join Date
    Mar 2004
    Location
    England
    Posts
    15
    Pat

    Thanks for the help. I really appreciate it.

Posting Permissions

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