无法访问目标表

Question

我做一个数据复制，用到SqlBulkCopy。
                        using (SqlBulkCopy bulkCopy = new SqlBulkCopy(SqlCons))
                        {
                            bulkCopy.DestinationTableName = "[2e5eData].[dbo].[Clothing.NewsInfo]";
                            bulkCopy.ColumnMappings.Add("TypeName", "TypeCard");
                            bulkCopy.ColumnMappings.Add("Title", "Title");
                            bulkCopy.ColumnMappings.Add("Content", "NewsContent");
                            bulkCopy.ColumnMappings.Add("Source", "NewsSource");
                            bulkCopy.ColumnMappings.Add("Times", "Time");
                            bulkCopy.ColumnMappings.Add("KeyWord", "KeyWords");
                            try
                            {
                                bulkCopy.WriteToServer(oleReader);
                            }
                            catch (Exception e)
                            {
                                return false;
                            }
                            finally
                            {
                                oleReader.Close();
                            }
                            return true;
                        }
在bulkCopy.WriteToServer(oleReader);出错，“无法访问目标表”

Answer 1

无法访问  也就是你的数据表权限不够或者连接不通
可在数据库设置对应的表，权限设置为你需要的

Answer 2

我也报了这个错，结果是连错数据源，找不到那个表，，你也检查看看