question

VivekD-8637 avatar image
0 Votes"
VivekD-8637 asked ·

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

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.

sql-server-integration-services
· 3
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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 …?

0 Votes 0 ·

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.

0 Votes 0 ·

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered ·

Hi @VivekD-8637 ,

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.




· 2 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @VivekD-8637 ,

May I know if you have anything to update?

Best regards,

Mona

0 Votes 0 ·

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.

0 Votes 0 ·