I have an SSIS package that is scheduled to run every 5 minutes by the SQL
Server Agent. I only want to allow one instance of the package to run at the
same time so it does not step on itself when it is doing some file and
database activity. Is there some easy solution to this? I though of using a
singleton in the db to limit the package execution, but I would prefer a
built in option.

Thanks
-Jeff

I am sure there is nothing in the box that does this for you. When rolling
your own the package level pre-execute and post-execute events would be
ideal to raise and lower your semaphore flag or similar.

Darren

"Jeff Darlington" <jdarlingtonR7 (AT) community (DOT) nospam> wrote