Skip to main content

Check Constraints

SSIS Destination configuration for checking constraints. Defaults to False, as that is recommended for data warehouse destinations.

The value is emitted as the CheckConstraints fast-load property on the OLE DB destinations in the generated data flows, determining whether table constraints are checked while rows are bulk inserted.

When to Change This Setting​

Keep the default N for warehouse loads, where constraint checking during bulk insert costs performance and integrity is managed by the load patterns. Enable it only when the target tables carry constraints that must be enforced row-by-row during the insert.

SettingInteraction
Maximum Insert Commit SizeCompanion fast-load option on the same destinations
Rows Per BatchCompanion batch-size option on the same destinations

Notes​

  • This setting is part of the SSIS settings category.
  • The default value for this setting is N.