Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    1

    Unanswered: [MSSQLServer] [DTS] How to avoid a DTS Package be reentrant

    Hello.
    I am designing a DTS package that should not to be executed more than two instances of this package.
    Something like "If App.PrevInstance = True Then End" in Visual Basic, but I want to do the similar thing with my DTS Package, so that the same package will not be executed (just quit) in same time.
    I'm wondering if I can add an ActiveX step to cope with this, to validate whether the following steps can be controlled to be executed or not.
    Thank you in advance,
    Nok

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Search SQLDTS website for any examples.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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