SSIS package does not show MySQL views in ODBC Source

VivekD 116 Reputation points
2021-03-01T21:13:55.277+00:00

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?

73066-image.png

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,776 Reputation points
    2021-03-02T02:36:47.217+00:00

    Hi @VivekD ,

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

    Please refer to the following pictures:
    73154-sqlquery.png
    73155-odbcsource.png
    73246-dataaccessmode.png

    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.