A table lock is a table-scoped restriction used during an SSIS OLE DB fast-load operation. For a flat staging-table load, enabling it avoids contention and reduces lock-escalation overhead. section 6.2
Flat-file load into a staging table
A staging table without keys, constraints, or NULL constraints can use the table-lock option without needing to tune those constraint-related settings. If constraints exist, enabling them can impose a performance penalty, so test the complete load configuration with realistic data. section 6.2
Apply the setting alongside batch and transaction choices:
- Configure maximum batch size and commit size rather than loading all rows in one transaction, which can increase TempDB use and fill the transaction log. section 6.2
- Test multiple buffer and batch sizes; the best value depends on the environment, resources, workload, and data profile. section 6.2
