Friday, February 24, 2012

Avoid multiple packages to run concurrently

Is there any way to avoid multiple packages to run concurrently on the same SSIS server ?

There is nothing built in to allow this (unless you can somehow restrict the number of instances of dtexec.exe that are allowed). You would have to build functionality into all your packages that (e.g.) places a zero-byte file onto the hard drive in a particular place when it starts and removes it when its finished. Each package should check to see if this file exists before it starts.

You could also check jaegd's suggestion here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1811745&SiteID=1

-Jamie

|||Thanks for your answer Jamie.

No comments:

Post a Comment