I had a small task to drag the data from the mariadb 5.5 database into MS SQL 2014.

I installed the required ODBC driver (for some reason, on win10, you need to install not x64 version, but x32), not without a tambourine, but configured ODBC Source. Actually, there is nothing left: choose where and where to transfer the data, but wait until half a million records are flooded.

However, an error occurred in the process:

  • Setting Source Connection (Error) Messages Error 0xc02020ff: Source - field_name [1]: Field information for the SQL command. The following error occurred: ERROR [42000] [MySQL] [ODBC 5.3 (w) Driver] [mysqld-5.5.57-MariaDB] check the SQL Server Import and Export Wizard
    Pipeline component has HRSULT error code 0xC02020FF from a method call. (Microsoft.SqlServer.DTSPipelineWrap)

How to fix?

1 answer 1

I found the answer in the question Data Transfer from MySql to SQL server using SSMS :

  • Open ODBC Settings

  • Click on the Details button

  • Select the Connection tab

  • In the Initial Statement field enter: set session sql_mode=ansi_quotes;

Odbc params