restricting multiple executions of a DTS

#1

Hi,

I have a DTS that is run once a day, however recently it was accidentally
run twice at the same time. Is there a way to stop a DTS from being executed
simultaneously by two different people?

Thanks

#2

Wenzu,

You can create a token record in a file/table indicating that a package is
running and look for the record at the beginning of the process.

Ilya

"Wenzu" <Wenzu (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

I have a DTS that is run once a day, however recently it was accidentally
run twice at the same time. Is there a way to stop a DTS from being
executed
simultaneously by two different people?

Thanks

#3

Nope the way Ilya has given you is the way to do it.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

"Wenzu" <Wenzu (AT) discussions (DOT) microsoft.com> wrote

Quote:

Cheers for the suggestion,

I had thought about that solution but was hoping for a more elegant way of
solving this (i.e. without creating the suggested control record/table).

I guess I was expecting to be able to set a property of the DTS within SQL
Server to perform this restriction.

Any other thoughts?

Wenzu

"Ilya Margolin" wrote:

Wenzu,

You can create a token record in a file/table indicating that a package
is
running and look for the record at the beginning of the process.

Ilya

"Wenzu" <Wenzu (AT) discussions (DOT) microsoft.com> wrote in message
news:E227F2FC-187B-4C0A-A5E2-D554A7BD1F7A (AT) microsoft (DOT) com...
Hi,

I have a DTS that is run once a day, however recently it was
accidentally
run twice at the same time. Is there a way to stop a DTS from being
executed
simultaneously by two different people?

Thanks

#4

ok. Thanks for your help guys.

"Allan Mitchell" wrote:

Quote:

Nope the way Ilya has given you is the way to do it.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

"Wenzu" <Wenzu (AT) discussions (DOT) microsoft.com> wrote in message
news:08AC5A5D-E4B1-4AB9-A866-2645593BC24E (AT) microsoft (DOT) com...
Cheers for the suggestion,

I had thought about that solution but was hoping for a more elegant way of
solving this (i.e. without creating the suggested control record/table).

I guess I was expecting to be able to set a property of the DTS within SQL
Server to perform this restriction.

Any other thoughts?

Wenzu

"Ilya Margolin" wrote:

Wenzu,

You can create a token record in a file/table indicating that a package
is
running and look for the record at the beginning of the process.

Ilya

"Wenzu" <Wenzu (AT) discussions (DOT) microsoft.com> wrote in message
news:E227F2FC-187B-4C0A-A5E2-D554A7BD1F7A (AT) microsoft (DOT) com...
Hi,

I have a DTS that is run once a day, however recently it was
accidentally
run twice at the same time. Is there a way to stop a DTS from being
executed
simultaneously by two different people?

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

restricting multiple executions of a DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

restricting multiple executions of a DTS - 09-08-2004 , 05:57 AM

Re: restricting multiple executions of a DTS - 09-08-2004 , 09:41 AM

Re: restricting multiple executions of a DTS - 09-08-2004 , 03:26 PM

Re: restricting multiple executions of a DTS - 09-09-2004 , 02:51 AM