SSIS Package Property Settings

These properties are grouped into different sections that include:

• SSIS Package (Extraction Task) Properties
  • Isolation Level, default is ReadCommitted
  • Transaction Option, default is Supported

• Package Level Property

  • Protection Level, default is ServerStorage
  • Password, default is blank
  • Confirm Password, default is blank

• Fast Load Options

  • No Locking on SQL Tables, default is unchecked
  • Max Insert Commit Size, default is blank
  • Rows Per Batch, default is blank

• Data Flow Buffer

  • Default Buffer Max Rows, default is blank
  • Default Buffer Size, default is blank