SSIS package does not show MySQL views in ODBC Source

Vivek Devalkar 122 Reputation points

I recently upgraded to SQL Server 2019 and VS 2019 in my laptop from 2017 and since then I am having an issue with SSIS packages.

I had several packages with ODBC data source that pulled data from MySQL views and loaded them into SQL tables.

Since the upgrade however, I am not able to see the views in the dropdown list as shown in the screenshot below.

Anyone has any thoughts/ideas on why this could be?


SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,489 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Monalv-MSFT 5,896 Reputation points

    Hi @Vivek Devalkar ,

    Please set Data Access Mode as SQL command in ODBC data source.

    Please refer to the following pictures:

    Best regards,


    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.