With SqlBulkCopy, the timeout has elapsed.

Question

.net asp.net sql sqlbulkcopy sql-server

I'm using SqlBulkCopy to restore tables from xml backups. One of the table backup is ~200MB large and has a lot of records.

I'm having error:

Timeout expired.
The timeout period elapsed prior to completion of the operation or the server
is not responding.

There are two ways to fix this error:

Increase Timeout by default it is 30 second and 0 means infinite.
```
   sqlBulkCopy.BulkCopyTimeout = {time in seconds}
```

Decrease BatchSize by default it try to insert all rows in one batch

    sqlBulkCopy.BatchSize  = {no of rows you want to insert at once}

Related Questions