Posted Wed, 29 Aug 2018 13:12:05 GMT by
<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.

Posted Sat, 11 May 2019 03:47:37 GMT by jacob alley

Hi Ash, The OleDbDestination node has both a "TableLock" and a "CheckConstraints" attribute that can be set to false. Setting it like so:

<OleDbDestination Name="dest" ConnectionName="OleDbConnection1" TableLock="false" CheckConstraints="true">

sets the output to: CHECK_CONSTRAINTS

<property id="47" name="FastLoadOptions" dataType="System.String" state="default" isArray="false" containsID="false" expressionType="None">CHECK_CONSTRAINTS</property>

You must be signed in to post in this forum.