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

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.