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
shahharsh
