bulkinsertorupdateasync：从BCP客户端收到无效的列长度

Question

因此，我正在运行以下代码：

await _internalDb.BulkInsertOrUpdateAsync(results, bulkConfig, (progress) =>
                {
                    log.BulkUpsertProgress(progress);
                });

我得到了以下例外：

Received an invalid column length from the bcp client for colid 4

现在我试图确定哪个列引起了此问题。因此，经过研究后，我遇到了这个网站： https://www.c-sharpcorner.com/blogs/received-invalid-column-column-length-from-bcp-client-for-for-volid-n1

现在我将上述代码包装到尝试捕获块：

try
            {
                await _internalDb.BulkInsertOrUpdateAsync(results, bulkConfig, (progress) =>
                {
                    log.BulkUpsertProgress(progress);
                });
            }
            catch (Exception ex)
            {
                string message = string.Empty;
                if (ex.Message.Contains("Received an invalid column length from the bcp client for colid"))

                {
                    string pattern = @"\d+";
                    Match match = Regex.Match(ex.Message.ToString(), pattern);
                    var index = Convert.ToInt32(match.Value) - 1;

                    FieldInfo fi = typeof(SqlBulkCopy).GetField("_sortedColumnMappings", BindingFlags.NonPublic | BindingFlags.Instance);
                    var sortedColumns = fi.GetValue(bulkcopy);
                    var items = (Object[])sortedColumns.GetType().GetField("_items", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(sortedColumns);

                    FieldInfo itemdata = items[index].GetType().GetField("_metadata", BindingFlags.NonPublic | BindingFlags.Instance);
                    var metadata = itemdata.GetValue(items[index]);
                    var column = metadata.GetType().GetField("column", BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance).GetValue(metadata);
                    var length = metadata.GetType().GetField("length", BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance).GetValue(metadata);
                    message = (String.Format("Column: {0} contains data with a length greater than: {1}", column, length));
                }
                return message;
            }

现在，我在这一点上停留的地方是如何更换块状副本。因此，我想做的是清楚地定义例外，并找出引起问题的列/值。任何帮助将不胜感激。

提前致谢