SQL Server 集成服务
文本被截断或者一个或多个字符在目标代码页中不匹配。 从Excel导入数据时如何实际避免此错误
Text was truncated or one or more characters had no match in the target code page.
how to avoid this error practically while import data from excel
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
一般来说，这可能是由于源文件中的数据与要进入的字段相比太长、数据的格式不同（源到目标）或其他类似的原因造成的。但是，既然您提到它来自 Excel，您可能也想尝试此解决方案，该解决方案仅适用于 Excel：
将包设置为在 32 位模式下运行。单击顶部菜单上的
项目，然后选择数据导入属性。单击配置属性->调试并将Run64BitRuntime设置为false。此解决方案有时适用于 Excel 项目，但它是一个外部镜头。如果它不起作用，请尝试查看源中的数据格式和字段（以及它们导入的内容）。
In general, this could be caused by the fact that you have data that is too long in your source file compared to the field it is going into, the data is in different formats (source to destination), or something else in general like this. However, since you mentioned that it is coming from Excel, you might want to try this solution too, which works only for Excel:
Set your package to run in 32-bit mode. Click on
Projecton the top menu and selectData Imports Properties. Click onConfiguration Properties->Debuggingand set theRun64BitRuntimetofalse.This solution sometimes works for Excel projects, but it is an outside shot. If it doesn't work, try look at the data formats and fields in the source (and what they are being imported as).