How to set the FastLoadOptions on an OLEDbDestination
<OleDbDestination ValidateExternalMetadata="false" ConnectionName="Connection_RAPID_Scheduling" Name="OLE DER - SCD Audit on RAPID_DataScheduling">
<ExternalTableOutput Table="dbo.scd_audit"></ExternalTableOutput>
</OleDbDestination>
This is a really basic object for Auditing. When executed, amongst everything else, it generates a property called FastLoadOptions
<property dataType="System.String" description="Specifies options to be used with fast load. Applies only if fast load is turned on."
name="FastLoadOptions">TABLOCK,CHECK_CONSTRAINTS</property>
Is there a flag or option I can use to turn off TABLOCK? Check_Constraints should remain on.
Comments
Hi Ash, The OleDbDestination node has both a "TableLock" and a "CheckConstraints" attribute that can be set to false. Setting it like so:
sets the output to: CHECK_CONSTRAINTS
Please sign in to leave a comment.