Error: Data index must be a valid index in the field
Posted by: Stanley Roper
Date: October 05, 2024 05:52AM

I'm using the MySQL Connector/NET driver with the SQL Server Import and Export Wizard to transfer data from a MySQL 5.7 database to SQL Server. There's one particular table (named "datablob") that contains thirty gigabytes of longblob data (about 24K records). After several seconds into the transfer, it stops with the following error:

Error 0xc020f444: Data Flow Task 1: The error "Data index must be a valid index in the field" occurred while processing "Source - datablob.Outputs[ADO NET Source Output].Columns[data]".

Does anyone know what this error means and how to fix? Is the problem with a particular record in the table, a configuration setting with the driver, or a bug?

Thank you!

Options: ReplyQuote


Subject
Written By
Posted
Error: Data index must be a valid index in the field
October 05, 2024 05:52AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.