SSIS Destination Locking

See Top 10 SQL Server Integration Services Best Practicesfor some useful information on making SSIS work better for you.

Found this one when trying to work out the best values for preventing lock escalation in our SQL server when inserting lots of records into live environment. Setting small commit size of <5000 is recommended.

This is found in the OLE DB Destination Editor window.

Add comment

Loading