How to Insert more than 1000 record using SqlBulkCopy
<p><strong>I need to insert more than 1000 records into SQL Server. But using my code I am able to insert only 1000 records. Please help me.</strong></p>

<pre><code>using (SqlBulkCopy s = new SqlBulkCopy(dbConnection,SqlBulkCopyOptions.UseInternalTransaction, null))
{
     s.DestinationTableName = TableName;
     s.BatchSize = 10000;
     s.BulkCopyTimeout = 1800;
     foreach (var column in dt.Columns)
     {
         s.ColumnMappings.Add(column.ToString(), column.ToString());
     }
     s.WriteToServer(dt);
}
</code></pre>