Post reply

Prevention of running a package twice at a time

  • April 16, 2010 at 7:47 am

    #219296

    Hi all,

    Please help me out with the following issue. How to prevent a packge from running twice or more then once at a time.

    For example, a package can be run even after creating a job also. So when we run package as well as job simutaneously, it doesn't give any error. This needs to be prevented. Please look into the issue and help me out as soon as possible...

    Thank you in advance.

  • April 16, 2010 at 1:32 pm

    #1153116

    You could add a step at the beginning of the process to set a flag in a table to 1 and set it back to 0 once it's completed. When you start the package you could check to see what the value is for that flag. If it's 1 end the package. It's worked well for me.

  • April 16, 2010 at 2:53 pm

    #1153152

    How do you handle the case where the package dies in process?

    CEWII

  • April 16, 2010 at 3:18 pm

    #1153171

    I used an onError event handler to mark the flag back to 0. In the event that I couldn't connect to the database, I have a job that will look at the table that contains the flag and change anything that has been running for n number of minutes.

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

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