Forum Discussion

Oviwan's avatar
Oviwan
Advocate I
3 months ago
Solved

Intermittent TCP Provider: Error code 0x68 (08S01) during bulk INSERT full loads into Fabric SQL DB

Hi Fabric community We are experiencing intermittent connection failures when performing full data loads using bulk INSERT statements into a SQL Database in Microsoft Fabric. The error typically oc...
SQL database
  • V-yubandi-msft's avatar
    V-yubandi-msft
    3 months ago

    Hi HugoQueiroz-MSF ,

    Thank you for the detailed update. Since you’ve already adjusted the ODBC/TCP settings and attempted table slicing, it seems the issue may be related to intermittent connection drops during lengthy bulk load operations.

    For very large tables, consider loading the data into a staging table first and using smaller commit batches rather than a single large transaction. Importing the data in smaller partitions or incremental ranges can also help improve load stability.

    It could also be helpful to test a Lakehouse or Pipeline based loading method in Microsoft Fabric, rather than relying on a single, long running bulk INSERT via ODBC. Private Link may enhance connection stability once it’s available for Fabric SQL Database, though this isn’t confirmed yet.

     

    Please try these approaches and let us know the behavior so we can review further.

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
3 months ago

Hi Oviwan ,

If you get a chance, please review the responses shared by HugoQueiroz-MSF  . They have correctly pointed out the key points, so kindly check and let us know if you need any additional details.

 

HugoQueiroz-MSF  Thank you for your valuable response.