Additional properties to SSIS property settings for performance tuning

Beginning with DWD 11.3.1 HF14, in the Fast load options, ‘Rows per batch’ property is added to work with ‘Max insert commit size’. This property can be set depending on the expected incoming records from data source. It aims to break them into multiple batches that can change the query performance for OLE DB connection.

A new section that will adjust the expected data SSIS can carry through a buffer by managing the Data Flow buffer, Default Buffer Max Rows and Default Buffer Size.

These properties can be defined to individual SSIS package or staging. It will take precedence over those defined in Repository Options Data Pump.