Azure Copydata Error

Try this as workarounds:

1. Enable KeepAlive on Source Connection

If you're using a self-hosted integration runtime or connecting to MySQL/PostgreSQL:

• Add Keepalive=15 or similar to the connection string.
• This keeps the TCP connection alive and avoids idle disconnects.

2. Partition the Copy Activity

Instead of copying all 1.5M rows at once:

• Use a ForEach loop with SQL partitioning.
• Partition by date, ID range, or another logical slice.
• Example: Copy 100K rows per partition using a query like:

SELECT * FROM table WHERE ID BETWEEN 1 AND 100000

3. Set CommandTimeout in Linked Service

"connectVia": {
  "referenceName": "YourIntegrationRuntime",
  "type": "IntegrationRuntimeReference"
},
"typeProperties": {
  "connectionString": "...",
  "CommandTimeout": "1800"
}

This sets the timeout to 30 minutes. Adjust as needed.