Avoid multiple processing of SSIS package (Running package cannot be re-executed)

• matmar

  SSC Enthusiast

  Points: 184

  More actions

  October 8, 2012 at 6:28 am

  #269033

  Hi,

  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.

  Thanks!

• Koen Verbeeck

  SSC Guru

  Points: 259165

  More actions

  October 10, 2012 at 12:19 am

  #1547469

  You should keep a log table somewhere where you log a record at the beginning of the package stating that the package is already running.

  Before this task, add another task that gets the last entry of that log table, check the date and see if it is already running or not. Use an expression on the precedence constraint to determine if you are proceeding with the package or not.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• matmar

  SSC Enthusiast

  Points: 184

  More actions

  October 10, 2012 at 1:29 am

  #1547496

  ...good idea! Thanks for your help.