I am executing an SSIS package with DTEXEC. How can I prevent that SSIS executes the same package more than once?
Example: I double-click on the DTEXEC command, the SSIS package is running, I double-click on the DTEXEC command again --> Now the SSIS package should not be executed because it is already running.
asked Oct 09, 2012 at 07:24 AM in Default
I think we need more information. Why are you starting it a 2nd time when you dont want to? Surely you start it and wait for it to complete before starting it again.
It may be easier to identify that it is running if you add it to a SQL Agent job and then you can see whether the job is running or not.
answered Oct 09, 2012 at 02:47 PM
What do you mean with "put the logic in the SSIS package itself"? Did you think about something like this: Control flow in the beginning of the package which checks the status. If it is Running than quit else Run the package.
I hoped there was a simple answer to this question. Is there a package property, an SSIS property or something else which prevents multiple processing?
answered Oct 09, 2012 at 04:03 PM