Blog about Business Intelligence,Data Science and Big Data Technologies.
Tuesday, July 31, 2012
SSIS Parallel Processing
In SSIS one of the key metric that is observed is how well the SSIS packages are performing. The ETL operations become critical to the the availability of data marts/data warehouse which are used for different types of reporting by Business. One of the package level property that is available in SSIS is MaxConcurrentExecutables, please see image below: