The attempt to send a row to SQL Server failed with error code 0x80004005
Hi, there are many similar posts, but i still haven't fount the solution. The error occurs in a data flow which consists of several OLE DB data sources (SQL 2008), few merge joins, union all , few lookups and SQL Server destination (same SQL 2008 as data source). Full error: Error: 0xC02020C7 at FactNarocila, Factnarocila [346]: The attempt to send a row to SQL Server failed with error code 0x80004005. Error: 0xC0202009 at FactNarocila, Factnarocila [346]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E14 Description: "OLE DB provider 'BULK' for linked server '(null)' returned invalid data for column '[BULK].Kolicina'.". Error: 0xC0047022 at FactNarocila, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Factnarocila" (346) failed with error code 0xC02020C7 while processing input "SQL Server Destination Input" (362). 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. Error: 0xC0047022 at FactNarocila, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Union All" (1609) failed with error code 0xC0047020 while processing input "Union All Input 4" (1710). 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. Information: 0x40043008 at FactNarocila, SSIS.Pipeline: Post Execute phase is beginning. Error: 0xC02092B5 at FactNarocila, Factnarocila [346]: A commit failed. Error: 0xC0047018 at FactNarocila, SSIS.Pipeline: component "Factnarocila" (346) failed the post-execute phase and returned error code 0xC02092B5. The package worked fine for 6 months, and no changes were made. It also works on my machine, with the same data. Any ideas? Thx, Janez
December 28th, 2010 9:43am

Just in time of writing the question I thought to change data destination to OLE DB. The error was still there, but this time it was meaningful (one column ha overflowed). So the right answer is not to use SQL Server destination:)
Free Windows Admin Tool Kit Click here and download it now
December 28th, 2010 10:38am

"An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E14 Description: "OLE DB provider 'BULK' for linked server '(null)' returned invalid data for column '[BULK].Kolicina'."." Seems like the data coming from source is not compatible with destination columns, Maybe Destination does not accept Null values and your source has Null Values? Maybe source data has some data that is not fitting into destination column? Check the data type of this column in package '[BULK].Kolicina and then check the Data type of same columns you are using in Union all and see if there is something you are missing. Good luck. Thanks
December 28th, 2010 10:43am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics