'System.Byte' to type 'System.Char[]'.
Posted by: Michael Peterson
Date: June 04, 2010 08:24AM

I am experiencing some issues moving data from SQL 2008 to MySQL 5.0.77 using SSIS 2008. The error I receive is

"Error: 0xC020844B at Data Flow Task, ADO NET Destination [1566]: An exception has occurred during data insertion, the message returned from the provider is: Unable to cast object of type 'System.Byte' to type 'System.Char[]'."

I do not have any 'BYTE' data types in my source, nor BIT types that are stored in together in a byte. I do not know why it is trying to convert from BYTE to CHAR. I am using an ADO.NET destinition using the 5.1 ODBC driver. My Source has some MSSQL data types like REAL and MONEY. I've used DECIMAL(19,4) and DOUBLE in MySQL destination.

Has anyone come across this error before and have any suggestions as to where I should look for a solution?

Options: ReplyQuote


Subject
Written By
Posted
'System.Byte' to type 'System.Char[]'.
June 04, 2010 08:24AM


Sorry, you can't reply to this topic. It has been closed.

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.