I am having an issue with my ODBC connection on SSIS and Snowflake. After configuring and installing both the 32-bit and 64-bit ODBC drivers simultaneously, I tested each one individually, but I encountered the same error.
The error in question is that my connection is successfully established between SSIS and Snowflake; I am able to display the tables from the SSIS ODBC Source component. However, when attempting to map the columns, I do not see any columns, and I no longer see any data in the connection manager.
enter image description here here is the image