，连接）;
connection.Open（）;
//创建DbDataReader到数据工作表
DbDataReader dr = command.ExecuteReader（）;

// SQL Server连接字符串
字符串sqlConnectionString = @数据源= ITBITSDT003-PC;初始目录= prajakta_erp_dhanshree; Integrated Security = True;

//批量复制到SQL Server
SqlBulkCopy bulkInsert = new SqlBulkCopy（sqlConnectionString）;
bulkInsert.DestinationTableName =attendance_sample;
bul kInsert.WriteToServer（DR）;
lbl_msg.Text =内容已成功添加......！;
}
catch（Exception ex）
{
lbl_msg.Text = ex.Message;
}

}

", connection); connection.Open(); // Create DbDataReader to Data Worksheet DbDataReader dr = command.ExecuteReader(); // SQL Server Connection String string sqlConnectionString = @"Data Source=ITBITSDT003-PC;Initial Catalog=prajakta_erp_dhanshree;Integrated Security=True"; // Bulk Copy to SQL Server SqlBulkCopy bulkInsert = new SqlBulkCopy(sqlConnectionString); bulkInsert.DestinationTableName = "attendance_sample"; bulkInsert.WriteToServer(dr); lbl_msg.Text = "Contents Added Successfully...!"; } catch(Exception ex) { lbl_msg.Text = ex.Message; } }

此代码给出了以下错误

This code gives me the following error

Received an invalid column length from the bcp client for colid 5.

请帮忙我要解决这个错误，并提前感谢大家

Please help me to solve this error and thanks in advance to you all

需要用varchar指定长度，否则需要30作为默认长度。所以只需给出适当的长度，如varchar（Max）或varchar（1000）

Need to specify length with varchar otherwise it takes 30 as default length. So just give proper lenght like varchar(Max) or varchar(1000)