Is it possible to run a package more than once at the same time?
Is it possible to run a package more than once at the same time? If yes, is there anything to be worried about...?Mr Shaw
November 12th, 2010 5:23am

It is possible, yes, but you need to be wary. There is, obviously, every chance that both instances will try and access an external resource at the same time as the other. If that is a resource that SSIS takes a lock on (e.g. a file) then you run the risk that one of the instances will fail because it can't get the required lock ("Another process has locked the file"). Hope this helps. @Jamiethttp://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2010 5:57am

is it possible to restrict the system so that the package can only be run once at any one time?Mr Shaw
November 12th, 2010 7:28am

Only by using some sort of manually controlled singleton pattern (e.g. flip a flag when a package starts to execute, flip it back when it completes) http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2010 7:40am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics