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