MaxConcurrentExecutables property in SSIS Packages
Let’s learn about the MaxConcurrentExecutables property in SSIS
- It’s a property of Control Flow. The value of the property is an Integer that contains the number of threads that a package can create.
- Gets or sets the maximum number of threads a package can create.
- Default value is -1 that means add 2 to the number of processor and use that value to execute the number of tasks in parallel. For example , if server has 2 processors and the default value is specified, SSIS will allow upto 4 tasks to be run parallel.
- Valid values are 1 or higher and -1
- It is used when parallelism exists in the workflow or package. If workflow is a series of sequential precedence constraints than this property has no effect.
- If the number of possible parallel tasks are more than the number of allowable parallel tasks then some of the tasks will have to wait till the parallel threads are available.
Happy Learning !!!
By Harsh Shah
Categories: SSIS
shahharsh
How do I get to this window to edit the settings? I have been unable to find it.
Hi,
This property is available in package properties.
1. Open the SSIS project
2. Click on Control Flow Tab
3. Right click on the designer and click on Properties or press F4 for the properties
4. Once you get the properties window. Select your package name from the properties window.
5. Once you have displayed the package properties, you should be able to see maxConcurrentExecutable property.
Have a good day..
Thanks,
Harsh Shah