Here it is below a full dump of the SSIS complains. Please note that I imported the same data in the destination table by using a different tool already and everything is looking perfectly, I suppose that means the schema of the destination table is correct. What do I have to do here to actually use SSIS (the entire process is automated, I did it manually now but that is not acceptable in long term...)
在这里，它是在一个完全转储的SSIS抱怨。请注意，我已经使用不同的工具导入了目标表中的相同数据，并且一切看起来都很完美，我想这意味着目标表的模式是正确的。我在这里需要做什么才能真正使用SSIS(整个过程是自动化的，我现在手动完成了，但是从长远来看是不能接受的…)
[Flat File Source [170]] Error: Data conversion failed. The data conversion for column "City" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
[平面文件源[170]]错误:数据转换失败。列“City”返回状态值4的数据转换和状态文本“文本被截断，或者一个或多个字符在目标代码页中没有匹配”。
[Flat File Source [170]] Error: The "output column "City" (203)" failed because truncation occurred, and the truncation row disposition on "output column "City" (203)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
[平面文件源[170]]错误:“输出列”城市“(203)”失败，因为截断发生，而“输出列”城市(203)的截断行配置“(203)”指定截断失败。在指定组件的指定对象上发生截断错误。
[Flat File Source [170]] Error: An error occurred while processing file "G:\Share\Nationwide Charities Listing.csv" on data row 120.
[平面文件来源[170]]错误:处理文件“G:\Share\全国性慈善清单”时发生错误。在数据行120。
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.
The PrimeOutput method on component "Flat File Source" (170) returned error code 0xC0202092.
The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
There may be error messages posted before this with more information about the failure.
SSIS。管道)错误:SSIS错误代码DTS_E_PRIMEOUTPUTFAILED。组件“平面文件源”的原始输出方法(170)返回错误代码0xC0202092。当管道引擎称为PrimeOutput()时，组件返回失败代码。失败代码的含义由组件定义，但是错误是致命的，管道停止执行。在此之前，可能会出现错误消息，并提供有关失败的更多信息。
2 个解决方案
#1
2
Your data contains unicode characters i guess and the destination is varchar(23). Try to change it to nvarchar(23) and then import ?
您的数据包含unicode字符，我想，目的地是varchar(23)。试着把它改成nvarchar(23)然后导入?
#2
0
Use utf 8 and you will be fine. That is in the first screen after the welcome in the import export tool. That displays properly the accents.
使用utf8，你会没事的。这是在导入导出工具之后的第一个屏幕。这样就能正确显示口音。
#1
2
Your data contains unicode characters i guess and the destination is varchar(23). Try to change it to nvarchar(23) and then import ?
您的数据包含unicode字符，我想，目的地是varchar(23)。试着把它改成nvarchar(23)然后导入?
#2
0
Use utf 8 and you will be fine. That is in the first screen after the welcome in the import export tool. That displays properly the accents.
使用utf8，你会没事的。这是在导入导出工具之后的第一个屏幕。这样就能正确显示口音。