Big Data, Data Analytics and Data Science | BI-BIGDATA.com

SQL Server Integration Services (SSIS) allows parallel execution in two different ways

1) MaxConcurrentExecutables : It defines how many tasks (executables) can run simultaneously. It defaults to -1 which is translated to the number of processors plus 2. Please note that if your box has hyperthreading turned on, it is the logical processor rather than the physically present processor that is counted. Read more…