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
tomIdentifying 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/default.asp?url=/library/en-us/dtsprog/dtspapps_64z0.asp|||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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment