获取导入数据csv文件到sql2005 ..时出错? [英] Errors getting Import data csv file to 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导入和导出向导)
错误消息非常明确:
数据转换失败，因为(它将出现)您正在尝试导入对于要进入的字段而言太长的数据.
最好的解决方案是修改您的源XML(如果您一次完成一次，并且没有很多数据)，或者更改数据库定义以允许XML字段的最大长度.
.
但是csv文件不包含有关csv文件中存储的数据的数据类型的信息.
解决方案:
您必须手动将csv数据与数据类型，大小，长度与您要在其中导入的sqlserver表字段进行匹配.
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)解决方案The error messages are pretty explicit:
The data conversion failed, because (it would appear) you are trying to import data that is too long for the field it is going into.
The best solution would be either to modify your source XML (if you are doing this as a one off and there isn''t a lot of data) or to change the database definition to allow for the maximum length of your XML fields.
you want to import a csv file into sqlserver database table.
but csv file doesn''t contains information about datatypes of data stored in csv file.
SOLUTION:
you must to match your csv data manully with datatype, size, length with your sqlserver table fields in which u want to import.
这篇关于获取导入数据csv文件到sql2005 ..时出错?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
