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:


Sam Vanga , a MS BI Expert has explained this property in further detail along with some illustrations. The value of -1 is the default setting, it should not be altered without fully understanding the impact of the value.
The link to the artile is here:
http://www.sqlservercentral.com/blogs/samvangassql/2012/07/20/parallel-execution-in-ssis-with-maxconcurrentexecutables/
Hope this article is useful for developers working with SSIS packages.

2 comments:

  1. Thank you for posting this. I am just getting started with this and glad to know there are some settings while we know what they do, they are rarely adjusted.

    ReplyDelete
  2. Thank you for posting this. I am just getting started with this and glad to know there are some settings while we know what they do, they are rarely adjusted.

    ReplyDelete