Engine Threads
Maximum number of SSIS engine threads to employ. Override the value here to change the default SSIS behavior.
The value is applied as the EngineThreads property on the data flow tasks in the generated packages, capping how many worker threads the data flow engine may use. The default 10 matches the SSIS default.
When to Change This Setting
Keep the default for the straightforward source-to-target data flows BimlFlex generates. Lower the value to constrain resource usage on a busy server; raise it only when data flows with many parallel execution paths are demonstrably thread-starved.
Related Settings
| Setting | Interaction |
|---|---|
| Max Concurrent Executables | The package-level cap on concurrently running tasks, as opposed to threads within a data flow |
Notes
- This setting is part of the SSIS settings category.
- The default value for this setting is
10.