Search This Blog

Monday, November 8, 2010

Performance Bulletin: SSIS Index Issue

There is an issue in the DTSXETLEngine package that not properly rebuild the indexes of the fact tables, thus leading to Application performance degradation. This affects the following packages :
  • BPMC_ETL_Engine_v1.2.2
  • BPMC_ETL_Engine_v1.2.1
  • BPMC_ETL_Engine_v1.2.0
To solve, drop in the BPMC_ETL_Engine_v1.2.3.dtsx or install 120 Pack.

This issue does not apply to feeds using the DTS Engine.

No comments:

Post a Comment