从Excel导入数据时出现SQL错误 [英] SQL Error while importing Data From Excel

问题描述

我正在从Excel工作表中导入数据.我正在努力解决以下问题-

I am importing Data from excel sheet. I am struggling with the following problems -

• 执行(错误)消息错误0xc020901c:数据流任务1:输出"Excel"上的输出列"Intelligence"(21)发生错误源输出"(9).返回的列状态为:文本为截断或一个或多个字符与目标代码不匹配页."(SQL Server导入和导出向导)

• Executing (Error) Messages Error 0xc020901c: Data Flow Task 1: There was an error with output column "Intelligence" (21) on output "Excel Source Output" (9). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.". (SQL Server Import and Export Wizard)

错误0xc020902a:数据流任务1:输出列"Intelligence"(21)"失败，因为发生了截断，并且在输出列"Intelligence"(21)"上的截断行配置指定截断失败.截断错误发生在指定组件的指定对象.(SQL Server导入和导出向导)

Error 0xc020902a: Data Flow Task 1: The "output column "Intelligence" (21)" failed because truncation occurred, and the truncation row disposition on "output column "Intelligence" (21)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. (SQL Server Import and Export Wizard)

错误0xc0047038:数据流任务1:SSIS错误代码DTS_E_PRIMEOUTPUTFAILED.组件源-MainSheetData $"(1)上的PrimeOutput方法返回了错误代码0xC020902A.当管道引擎调用PrimeOutput()时，该组件返回失败代码.故障代码的含义由组件定义，但是错误是致命的，管道停止执行.可能有错误在此之前发布的消息，其中包含有关失败的更多信息.(SQL Server导入和导出向导)

Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source - MainSheetData$" (1) returned error code 0xC020902A. 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. (SQL Server Import and Export Wizard)

推荐答案

我正用同样的错误将头撞在墙上.

I was banging my head against the wall with this same exact error.

尝试导入到MS Access中，然后然后导入到SQL Server中.

Try importing into MS Access and then importing into SQL Server.

这篇关于从Excel导入数据时出现SQL错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！