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

Why is my docker.compose file not creating my database?
"Database logon failed" in Crystal Reports when using System DSN for MySQL Server
Can I access the MySQL keypair in a plugin?
MySQL - Update table values from another table
Find patients admitted multiple times for the same primary diagnosis in SQL
Connecting a Dockerized Spring Boot app to a local MySQL Database
MySql: unknown column id in 'field list'
Is there a simple tool to convert mysql to postgresql syntax?
Why UNION and UNION ALL don't work in my code?
laravel eloquent ->whereHas - write your own exists( subquery )
MySQL server does not start with MAMP
Forward Engineer not creating tables from Model in MySQL Workbench
How can I make SQL case sensitive string comparison on MySQL?
MySQL - problem with comparing strings constants containing national characters
How to fix "java.sql.SQLException: Can't call commit when autocommit=true"
Balance calculation problem with Foreign Exchange in Mysql
Database Backup From Laravel Application
Joining tables with multiple results as new columns?
how to calculate average price of each item in inventory php mysql
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
How can I rebuild indexes and update stats in MySQL innoDB?
In MySQL, how can I create a stored procedure to create the database itself and then call this procedure from Java using JDBC?
InnoDB: Unable to lock ./ibdata1 error: 35
MySQL Order subquery by the order that fields from another table come in
UPDATE/INSERT when modifying RDBMSs using drill
Searching within nested JSON entries in MYSQL
Selecting empty mysql datetime fields
SQL Query: order by length of characters?
how do i add database name with hyphen character using script in ubuntu
Laravel 11 forces creation of tables you don't want and crashes the app