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

    Unanswered: DTS package behaviour when used by > 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) ?

    Will User 1 simply have to wait untill the package completes for User 1?

    OR

    Will a new seperate 'instance' of the package be used by User 1?

    Any info would be very helpful

    Cheers

  2. #2
    Join Date
    Feb 2004
    Location
    Poland
    Posts
    96
    You will have problems
    the second DTS will start before the first stop

    (maybe it's not problem it depends what they do)

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

    Wink

    That was the answer i was hoping for really.

    Basically this shouldn't be a problem for my scenario. The Users of the System are accountants scattered at various locations around the country and each of them Updates the their own locations data (via the dts package)and so this will not conflict with any other user updating the DB as it is a different locations data.

    I was worried that if the user had to wait for the dts package to finish then i may occasionally have timeout issues (not that i haven't got a backup for this).

    Thanks for your help, mucho appreciated.

Posting Permissions

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