导入到 SQL
我正在使用导入向导将此 excel 文件导入到 sql 中，但每次无论我尝试什么，我都会收到截断错误，导致明显无法导入它。
- Executing (Error)
Messages
Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "Column 0" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
(SQL Server Import and Export Wizard)
Error 0xc020902a: Data Flow Task 1: The "output column "Column 0" (10)" failed because truncation occurred, and the truncation row disposition on "output column "Column 0" (10)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
(SQL Server Import and Export Wizard)
Error 0xc0202092: Data Flow Task 1: An error occurred while processing file "C:\Users\crover\Downloads\فراشات حواء-2\farashat.csv" on data row 17.
(SQL Server Import and Export Wizard)
数据库排序规则为阿拉伯_CS_AI，而导入向导将代码页属性设置为 1256，且未选中 Unicode。
I am using Import Wizard to import this excel file into sql but everytime no matter what i try i receive a truncation error resulting in not importing it obviously.
- Executing (Error)
Messages
Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "Column 0" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
(SQL Server Import and Export Wizard)
Error 0xc020902a: Data Flow Task 1: The "output column "Column 0" (10)" failed because truncation occurred, and the truncation row disposition on "output column "Column 0" (10)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
(SQL Server Import and Export Wizard)
Error 0xc0202092: Data Flow Task 1: An error occurred while processing file "C:\Users\crover\Downloads\فراشات حواء-2\farashat.csv" on data row 17.
(SQL Server Import and Export Wizard)
The database collation is Arabic_CS_AI while import wizard has the code page property set to 1256 with the Unicode unchecked.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
大多数时候，当您收到截断错误时，这是因为您要导入数据的列之一不够大。
删除尾随和前导空格可能有助于解决此问题。
Most of the time, when you receive a truncate error, it is because one of the columns you are importing your data to is not big enough.
Removing the trailing and leading spaces might help with this problem.