Improve performance of SSIS using defaultBufferSize
[et_pb_section admin_label=”section”][et_pb_row admin_label=”row”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” text_font_size=”14″ use_border_color=”off” border_color=”#ffffff” border_style=”solid”] Use the defaultBufferSize setting to improve the throughput of SSIS package. Key things you need to know: Each component in an SSIS data flow is assigned a memory buffer. The default is about 10MB. When your source is a wide table (i.e. has many or large…