question

VivekD-8637 avatar image
0 Votes"
VivekD-8637 asked Monalv-msft edited

SSIS package does not show MySQL views in ODBC Source

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
image.png (49.6 KiB)
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

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

1 Answer

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

Hi @VivekD-8637 ,

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.


sqlquery.png (74.7 KiB)
odbcsource.png (39.9 KiB)
dataaccessmode.png (58.3 KiB)
· 2
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

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

VivekD-8637 avatar image VivekD-8637 ·

Thanks @Monalv-msft . I am aware of the SQL Command option. I asked the question specifically to understand why the views were not showing up even though the documentation says one can select a table or a view. The views were showing up prior to the SQL Server and VS 2019 upgrade.

0 Votes 0 ·
Monalv-msft avatar image Monalv-msft VivekD-8637 ·

Hi @VivekD-8637 ,

Please put forward your needs on the website below.

SQL Server feedback

Best regards,
Mona


0 Votes 0 ·