SSIS ETL Conversion Issues

SSIS conversion from Unicode to Non-Unicode characters data set.
I received this when trying to ETL from MySQL to SQL Server:

varchar(100)-latin1_swedish_ci varchar
varchar(80)-utf8_general_ci Nvarchar


The value violated the integrity constraints for the column.

[OLE DB Destination [334]] Error: There was an error with OLE DB Destination.Inputs[OLE DB Destination Input].Columns[date_ordered1] on OLE DB Destination.Inputs[OLE DB Destination Input]. The column status returned was: "The value violated the integrity constraints for the column.".

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *