本文介绍了获取导入数据csv文件到sql2005 ..时出错?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我已经将数据从Csv文件导入到sql2005,我遇到了以下错误,请帮帮我..?



*错误0xc02020a1:数据流任务:数据转换失败.列列29"的数据转换被转换为列".返回状态值4和状态文本目标代码页中的文本被截断或一个或多个字符不匹配.".
(SQL Server导入和导出向导)

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

*错误0xc0202092:数据流任务:在处理文件"C:\ Users \ ravi \ Desktop \ Cus_csv.csv"时发生错误.在数据行16上.
(SQL Server导入和导出向导)

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

*错误0xc0047021:数据流任务:SSIS错误代码DTS_E_THREADFAILED.线程"SourceThread0&"已退出,错误代码为0xC0047038.在此之前可能会发布错误消息,并提供有关线程退出原因的更多信息.
(SQL Server导入和导出向导)

*错误0xc0047039:数据流任务:SSIS错误代码DTS_E_THREADCANCELLED.线程"WorkThread0&"收到关机信号并正在终止.用户请求关闭,或者另一个线程中的错误导致管道关闭.在此之前可能会发布错误消息,并提供有关为何取消线程的更多信息.
(SQL Server导入和导出向导)

*错误0xc0047021:数据流任务:SSIS错误代码DTS_E_THREADFAILED.线程"WorkThread0&"已退出,错误代码为0xC0047039.在此之前可能会发布错误消息,并提供有关线程退出原因的更多信息.
(SQL Server导入和导出向导)

解决方案


hi i have import the data from Csv file to sql2005 ,i am getting below errors please help me..?



* Error 0xc02020a1: Data Flow Task: Data conversion failed. The data conversion for column "Column 29" 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: The "output column "Column 29" (126)" failed because truncation occurred, and the truncation row disposition on "output column "Column 29" (126)" 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: An error occurred while processing file "C:\Users\ravi\Desktop\Cus_csv.csv" on data row 16.
(SQL Server Import and Export Wizard)

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

* Error 0xc0047021: Data Flow Task: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited.
(SQL Server Import and Export Wizard)

* Error 0xc0047039: Data Flow Task: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled.
(SQL Server Import and Export Wizard)

* Error 0xc0047021: Data Flow Task: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited.
(SQL Server Import and Export Wizard)

解决方案



这篇关于获取导入数据csv文件到sql2005 ..时出错?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

07-22 12:19
查看更多