There seems to be some kind of bug when using a PostgreSQL ODBC Data Source in SSIS (Version 1.5) in visual studio 2022.

I managed to make the ODBC Source work by using the "Advanced Editor ..." menu instead of the "Edit...". In it, I configured the query to use then used the "Refresh" button at the bottom of the page.

The speed increase over the ADO.Net source is really appreciable.