Post reply

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

  • 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!

  • 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

  • October 10, 2012 at 1:29 am

    #1547496

    ...good idea! Thanks for your help.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply