Home Forums Data Warehousing Integration Services SSIS speed loading Issue with "Table or view - Fast Load" option in the OleDBDestination component RE: SSIS speed loading Issue with "Table or view - Fast Load" option in the OleDBDestination component

  • January 30, 2015 at 7:39 am

    #1774349

    Indeed,

    I just did.

    I deployed again, although I am pretty sure I redeployed the new version.

    Below is the xml corresponding to the deployed file.

    <property

    dataType="System.Boolean"

    name="FastLoadKeepIdentity">false</property>

    <property

    dataType="System.Boolean"

    name="FastLoadKeepNulls">false</property>

    <property

    dataType="System.String"

    name="FastLoadOptions">TABLOCK,CHECK_CONSTRAINTS</property>

    <property

    dataType="System.Int32"

    name="FastLoadMaxInsertCommitSize">2147483647</property>

    Thanks