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
when i use Execute sql commande i have this issue : <ResultSetType_Rowset> I have correctly set the complete result set as Resultset. However, when I use the ADO.NET Source Manager, it works perfectly fine
