SSIS: Has anyone successfully loaded data from Mysql views to SQL Server 2019 tables?

Vivek Devalkar 122

There seems to be something wrong with either SQL Server 2019 or the SSIS MySQL connectors but I've just not been successful with loading data from MySQL views to SQL Server 2019 tables.

While I've tried several ways, I'd specifically like to know if there is anyone out there that has actually successfully done this.

Note: I have loaded from MySQL to SQL Server 2017 tables using the ODBC connector. My issue is specifically with SQL Server 2019.

Olaf Helper 40,816 Reputation points

2021-03-03T07:18:27.753+00:00

not been successful with loading data from MySQL views

And this means what in detail? Do you get an error message (which one) or the result from MySQL is empty or …?
Vivek Devalkar 122 Reputation points

2021-03-03T12:54:40.14+00:00

There are several issues I've encountered but the main intent of my question was to just to know if it had worked for anyone else so I at least know that the process/tool works and the problem is perhaps specific to my system.

Anyway, the main issue I'm facing with the ODBC connector is I get the error below when I run the same package that ran fine earlier with SQL Server 2017.

[ODBC Source [34]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "ODBC Source.Outputs[ODBC Source Output]" failed because error code 0xC020F450 occurred, and the error row disposition on "ODBC Source" specifies failure on error.

I've raised this issue in a separate thread so didn't want to repeat that here. All I'm looking for as an answer on this one is for someone to say yes I have and it works using either the ODBC or the ADO .Net connector.
Vivek Devalkar 122 Reputation points

2021-03-03T12:55:43.557+00:00

Here's the other thread for reference

https://learn.microsoft.com/en-us/answers/questions/294011/ssis-dts-e-inducedtransformfailureonerror-error-af.html

1 answer

Monalv-MSFT 5,891 Reputation points

2021-03-03T09:04:54.85+00:00

Hi @Vivek Devalkar ,

Please use ADO NET Source to load data from Mysql views.

We can refer to the following links:

1.How to migrate MySQL tables to SQL Server using the SQL Server Migration Assistant (SSMA) and SSIS

2.Connect to a MySQL Data Source (SQL Server Import and Export Wizard)

Best regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Monalv-MSFT 5,891 Reputation points

2021-03-07T09:27:04.673+00:00

Hi @Vivek Devalkar ,

May I know if you have anything to update?

Best regards,

Mona

Vivek Devalkar 122 Reputation points

2021-03-08T20:53:39.863+00:00

Nothing concrete but I eventually was able to get the SSIS packages to work by using an ODBC connector and using SQL queries where I converted all varchar fields to char.
Sign in to comment