SSIS: Source has UNICODE data; I'm using MySQL 64bit ANSI ODBC driver

Source has Unicode data but I am using MySQL 64 bit ODBC ANSI driver which is throwing an error after partial load (Errors out after it comes across few special characters) .

Is there any work around for this (other than switching to Unicode Driver)?

Solution

This worked: CONVERT(columnName USING ASCII) as columnName

How/when mysql compiles stored procedures?
UPDATE column with Y or N if data exists in another table
#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
How to get Python MYSQL connection username and password?
Table is marked as crashed and should be repaired
Coverting a .BAK file into a .SQL for use in XAMPP phpmyadmin
Query through JSON Array with multiple values in MySQL
Housing Society management system database structure
MySQL DROP all tables, ignoring foreign keys
When to use prepared statements?
When *not* to use prepared statements?
Are Prepared Statements a waste for normal queries? (PHP)
Deleting rows in mysql table that contain an empty field where more complete rows exist
MySQL given date between monday and sunday
JSON_TABLE - how to access fields inside escaped quotes?
mysqldump - maintain character set and collations
Why can't a text column have a default value in MySQL?
Using Hibernate's ScrollableResults to slowly read 90 million records
Foreign key in the child table is null after persisting @OneToMany
How to fix products without cover image in PrestaShop
Laravel Eloquent Query Using Case/When to apply conditions dynamically
MySQL SELECT a field as NULL if not existent in table
How can I show all duplicate value from a specific column in MySQL
Declaring 2 Cursors in a Stored Procedure | SQL Error [1338] [42000]: Cursor declaration after handler declaration
PHP mySQL - Insert new record into table with auto-increment on primary key
IF ROW_COUNT() return error
Date column with associated MAX count value
Drop Column from Large Table
MySQL - 'Using index condition' vs 'Using where; Using index'
Conversion issues in sql - GREATEST(CEILING())