导入数据时出错 [英] Getting Error While Import Data

问题描述

当我从Excel文件导入数据时（我在Excel中有大约15000条记录）复制记录时，一半记录正在成功复制，但随后发生错误

< pre lang =SQL> - 将复制到 [dbo]。[MP_29082013_Fifth]（错误）
消息
错误0xc0202009：数据流任务1 ：SSIS错误代码DTS_E_OLEDBERROR。发生OLE DB错误。错误代码：0x80004005。
OLE DB记录 可用。来源： Microsoft SQL Server Native Client 10.0 Hresult：0x80004005说明： 通讯链接失败。
OLE DB记录 可用。来源： Microsoft SQL Server Native Client 10.0 Hresult：0x80004005说明： TCP提供程序：已建立的连接已被主机中的软件中止。
。
（SQL Server导入和导出向导）

错误0xc0209029：数据流任务1：SSIS错误代码DTS_E_INDUCEDTRANSFORMFAILUREONERROR。 input目的地输入 < span class =code-string>（57）失败，因为错误代码0xC020907B发生，和错误行处置 on input目的地输入 （57）指定 错误。 发生错误指定组件的指定对象 。在此之前可能会发布错误消息有关失败的更多信息。
（SQL Server导入和导出向导）

错误0xc0047022：数据流任务1：SSIS错误代码DTS_E_PROCESSINPUTFAILED。 ProcessInput方法 on 组件 目的地 - MP_29082013_Fifth（ 44 ）失败 错误代码0xC0209029 而处理输入 目的地输入（ 57 < /跨度>）。标识的组件从 ProcessInput方法返回错误。错误 特定 组件，但错误是致命和将导致数据流任务 停止运行。在此之前可能会发布错误消息有关失败的更多信息。
（SQL Server导入和导出向导）

错误0xc02020c4：数据流任务1：尝试 to 添加行 数据流任务缓冲区失败 错误代码0xC0047020。
（SQL Server导入和导出向导）

错误0xc0047038：数据流任务1：SSIS错误代码DTS_E_PRIMEOUTPUTFAILED。 PrimeOutput方法 组件 Source - Medical_Professional_Final＃2 （ 1 ）返回错误代码0xC02020C4。当管道引擎名为PrimeOutput（）时，该组件返回了失败代码。 的含义 定义 组件，但错误 致命和管道停止执行。在此之前可能会发布错误消息有关失败的更多信息。
（SQL Server导入和导出向导）

解决方案

如果没有足够的可用内存或缓冲区大小太小，可能会出现问题，

所以试试这个

 sp_configure ' 显示高级选项'， 1 ; 
  GO  
  RECONFIGURE ; 
  GO  
 sp_configure '  max服务器内存'， 4096 ; 
  GO  
  RECONFIGURE ; 
  GO  

原始链接 - 两者都是不同的链接，通过评论你会明白更好



1. 所述-尝试到添加一个排至-the-data-flow-task-buffer-failed-with-error-code-0xc0047020 [ ^ ]



2. 错误的，企图到加一个排到的数据流任务缓冲失败的，有错误，鳕鱼e-0xc0047020 [ ^ ]





我从谷歌得到这些东西



快乐编码

When I am importing the data from the Excel File, (i have around 15000 record in Excel) while Copying of the record, half of the record is copying successfully but then Following error occurred

- Copying to [dbo].[MP_29082013_Fifth] (Error)
Messages
Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80004005  Description: "Communication link failure".
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80004005  Description: "TCP Provider: An established connection was aborted by the software in your host machine.
".
 (SQL Server Import and Export Wizard)
 
Error 0xc0209029: Data Flow Task 1: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "input "Destination Input" (57)" failed because error code 0xC020907B occurred, and the error row disposition on "input "Destination Input" (57)" specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure.
 (SQL Server Import and Export Wizard)
 
Error 0xc0047022: Data Flow Task 1: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "Destination - MP_29082013_Fifth" (44) failed with error code 0xC0209029 while processing input "Destination Input" (57). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.  There may be error messages posted before this with more information about the failure.
 (SQL Server Import and Export Wizard)
 
Error 0xc02020c4: Data Flow Task 1: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
 (SQL Server Import and Export Wizard)
 
Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on component "Source - Medical_Professional_Final#2" (1) returned error code 0xC02020C4.  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)

解决方案

the issue might occur if there is not enough memory available or the buffer size is too small,
So try with this

sp_configure 'show advanced options', 1;
  GO
  RECONFIGURE;
  GO
  sp_configure 'max server memory', 4096;
  GO
  RECONFIGURE;
  GO

Original links-Both are different links, go through comments you will understand better

1.the-attempt-to-add-a-row-to-the-data-flow-task-buffer-failed-with-error-code-0xc0047020[^]

2.error-the-attempt-to-add-a-row-to-the-data-flow-task-buffer-failed-with-error-code-0xc0047020[^]


and i got these things from google

Happy coding

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