I am getting below issue while performing bulk copy in c#
System.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) ---> System.ComponentModel.Win32Exception (0x80004005): The specified network name is no longer available at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connectionstr, SqlBulkCopyOptions.KeepIdentity))
{
bulkCopy.DestinationTableName = Table;
bulkCopy.BulkCopyTimeout = 0;
foreach (DataColumn dccolumn in dccolumns)
{
bulkCopy.ColumnMappings.Add(dccolumn.ColumnName, dccolumn.ColumnName);
}
// Write from the source to the destination.
bulkCopy.WriteToServer(dt);
bulkCopy.Close();
}
}
Please advise.