Home Forums Data Warehousing Integration Services Avoid multiple processing of SSIS package (Running package cannot be re-executed) RE: Avoid multiple processing of SSIS package (Running package cannot be re-executed)

  • 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