Ability to include "FIRE_TRIGGERS" in the FastLoadOptions used by Data Import/Export Framework


Data Import/Export Framework sets the FastLoadOptions to TABLOCK and CHECK_CONSTRAINTS by default. There is no way to modify this; having the ability to include FIRE_TRIGGERS has been requested.


A new configuration key "AddFireTriggersToFastLoadOptions" with default value false was added to DMFConfig.xml. By changing the value of this key to true, "FIRE_TRIGGERS" will be included in FastLoadOptions.

More information

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.