blocks|key|426156|text|检查以下内容：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|426157|文件末尾没有空行(保留最后一行的终止符完整)--这似乎是最常见的问题|unordered-list-item|426158|没有意外的空白列。|426159|没有转义错误的引号|426160|它看起来像导入过程以块的形式加载行。这意味着，最后一个成功加载的块后面的行可能没有错误。您需要查看后续行，这些行是失败块的一部分，以查找违规行。|426161|在处理大型文件时，这花费了我几个小时的时间。希望这能节省一些时间。|426162|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$]]|$1|E|3|F|5|D|7|Q|8|@]|9|@]|A|$]]|$1|G|3|H|5|D|7|R|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|S|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|T|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|N|$]]

Check the following:

<ul>
<li>that there are no blank lines at the end of the file (leaving the last line's line terminator intact) - this seems to be the most common issue</li>
<li>there are no unexpected blank columns</li>
<li>there are no badly escaped quotes</li>
</ul>

It looks like the import process loads lines in chunks. This means that the lines following the last successfully loaded chunk may appear to have no errors. You need to look at subsequent lines, that are part of the failing chunk, to find the offending line(s).

This cost me hours of hair pulling while dealing with large files. Hopefully this saves someone some time.

blocks|key|426182|text|如果您要导入的文件已经打开，SSMS将抛出此错误。关闭文件，然后重试。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|426183|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If the file you're importing is already open, SSMS will throw this error. Close the file and try again.

blocks|key|426171|text|确保在创建平面文件时，如果在任何列中都有文本(varchar)值，则不要选择您的文件为逗号+"，"分隔。相反，选择垂直行“AC.26”或您确信不可能出现在这些值中的东西。在nvarchar字段中，逗号是非常常见的。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|426172|我有这个问题，其他人的建议都帮不了我！我希望这能节省一些时间，我花了几个小时才弄明白！|426173|entityMap^0|9|4|Y|2|17|2|1A|3|1O|7|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]|$9|M|A|N|B|C]|$9|O|A|P|B|C]|$9|Q|A|R|B|C]|$9|S|A|T|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|U|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|I|$]]

Make sure when you are creating your flat-file IF you have text (varchar) value in any of your columns, DO NOT select your file to be comma "," delimited. Instead, select vertical line "|" or something that you are SURE it can't be in those values. the comma is supper common to have in nvarchar filed.

I have this issue and none of the recommendations from other answers helped me!
I hope this saves someone some times and it took me hours to figure it out!!!

blocks|key|1537792|text|其他的都不适合我，但是这件事：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1537793|导入平面文件时，SSMS将简要总结每列中的数据类型。每当您看到位于int或双列中的nvarchar时，将其更改为int或double。并将所有的nvarchars改为nvarchar(max)。这对我有用。|1537794|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

None of these other ones worked for me, however this did:
When you import a flat file, SSMS gives you a brief summary of the data types within each column. Whenever you see a nvarchar that's in an int or double column, change it to int or double. And change all nvarchars to nvarchar(max). This worked for me.

blocks|key|1537834|text|我已经处理csv数据很长时间了。我第一次开始这份工作时遇到了类似的问题，但是作为新手，我无法从异常中得到一个精确的错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1537835|在导入任何东西之前，您应该先看看这里的一些内容。|offset|length|style|BOLD|1537836|您的csv文件不能在任何软件中打开，例如Excel。|ordered-list-item|1537837|您的csv文件单元格不应包括逗号或引号。|1537838|在您的数据末尾没有不必要的空白。|1537839|没有使用保留的术语作为数据。在Excel中，打开您的文件并将其保存为一个新文件。|1537840|entityMap^0|0|G|8|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@$D|U|E|V|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|W|8|@]|9|@]|A|$]]|$1|K|3|L|5|J|7|X|8|@]|9|@]|A|$]]|$1|M|3|N|5|J|7|Y|8|@]|9|@]|A|$]]|$1|O|3|P|5|J|7|Z|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|R|$]]

I've been working with csv data for a long time. I encountered the similar problems when I first started this job, however as a novice, I couldn't obtain a precise fault from the exceptions.
Here are a few things you should look at before importing anything.
<ol>
<li>Your csv file must not be opened in any software, such as Excel.</li>
<li>Your csv file cells should not include comma or quotation symbols.</li>
<li>There are no unnecessary blanks at the end of your data.</li>
<li>There is no usage of a reserved term as data. In Excel, open
yourfile and save it as a new file.</li>
</ol>

blocks|key|1663364|text|在考虑了所有建议之后，如果有人仍然有问题，请检查您的列的DataType长度。我花了几个小时才弄明白这一点，但是把nvarchar长度从(50)增加到(100)对我来说是有效的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1663365|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

After considering all the suggestions, if anyone is still having issues, check the length of the DataType for your columns. It took hours for me to figure this out but increasing the nvarchar length from (50) to (100) worked for me.

blocks|key|1663414|text|有一件事对我有效:您可以在“修改列”中将错误范围更改为1。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1663415|图像以明确其所在位置|offset|length|1663416|使用文件中有问题的特定行获得错误消息，而不是“内存耗尽”|1663417|entityMap|0|LINK|mutability|MUTABLE|url|https://i.stack.imgur.com/Cv5An.png^0|0|0|A|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@$D|R|E|S|1|T]]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

One thing that worked for me : You can change the error range to 1 in &quot;Modify colums&quot;
<a href="https://i.stack.imgur.com/Cv5An.png" rel="nofollow noreferrer">Image for clarity of where it is</a>
You get an error message with the specific line that's problematic in your file instead of &quot;ran out of memory&quot;

When importing a seemingly valid flat file (csv, text etc) into a SQL Server database using the SSMS Import Flat File option, the following error appears:

<blockquote>
 Microsoft SQL Server Management Studio
 
 Error inserting data into table. (Microsoft.SqlServer.Import.Wizard)
 
 Error inserting data into table. (Microsoft.SqlServer.Prose.Import)
 
 Object reference not set to an instance of an object. (Microsoft.SqlServer.Prose.Import)
</blockquote>

The target table may contain rows that imported just fine. The first row that is not imported appears to have no formatting errors.

What's going wrong?

Import Flat File via SSMS to SQL Server fails

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

当使用SSMS导入平面文件选项将看似有效的平面文件(csv、text等)导入到Server数据库时，将出现以下错误：在表中插入数据时出错。(Microsoft.SqlServer.Import.Wizard)在表中插入数据时出错。(Microsoft.SqlServer.Prose.Import)对象引用未设置为对象的实例。(Microsoft.SqlServer.Prose.Import)目标表

问通过SSMS将平面文件导入Server失败
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问通过SSMS将平面文件导入Server失败EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问通过SSMS将平面文件导入Server失败
EN